SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-16-2008, 01:43 PM
| ||||
| ||||
 Adding variables for segment_size, wal_segment_size and block sizes Now that we have customizable segment sizes for heap and WAL at compilation time i would like to have some runtime variables to query that information (besides pg_controldata). I can imagine to have the following names: segment_size: Reports heap segment size wal_segment_size: Reports wal segment size block_size: Available yet wal_block_size: wal block size I'd like to implement them if we agree on them -- Thanks Bernd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers      |
|
05-18-2008, 10:03 PM
| |||
| |||
| Re: Adding variables for segment_size, wal_segment_sizeand block sizes Bernd Helmle wrote: > segment_size: Reports heap segment size > wal_segment_size: Reports wal segment size > block_size: Available yet > wal_block_size: wal block size > +1. We already have block_size in GUC. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |
|
07-01-2008, 07:10 AM
| |||
| |||
| Re: Adding variables for segment_size,wal_segment_size and block sizes Bernd Helmle wrote: > Now that we have customizable segment sizes for heap and WAL at compilation > time i would like to have some runtime variables to query that information > (besides pg_controldata). I can imagine to have the following names: > > segment_size: Reports heap segment size > wal_segment_size: Reports wal segment size > block_size: Available yet > wal_block_size: wal block size > > I'd like to implement them if we agree on them Bernd, have you made any progress on this? -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |
|
07-04-2008, 06:50 AM
| |||
| |||
| Re: Adding variables for segment_size, wal_segment_sizeand block sizes --On Montag, Juni 30, 2008 18:47:33 -0400 Bruce Momjian <bruce@momjian.us> wrote: >> >> I'd like to implement them if we agree on them > > Bernd, have you made any progress on this? Here's a patch for this. I'll add it to the commit fest wiki page if it's okay for you. -- Thanks Bernd -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |
|
07-04-2008, 03:38 PM
| ||||
| ||||
| Re: Adding variables for segment_size, wal_segment_sizeand block sizes On Thu, 2008-07-03 at 16:36 +0200, Bernd Helmle wrote: > --On Montag, Juni 30, 2008 18:47:33 -0400 Bruce Momjian <bruce@momjian.us> > wrote: > > >> > >> I'd like to implement them if we agree on them > > > > Bernd, have you made any progress on this? > > Here's a patch for this. I'll add it to the commit fest wiki page if it's > okay for you. It's small and uncontentious, please add it to the wiki. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers |
Linear Mode
