Re: [GENERAL] Help estimating database and WAL size

2012-10-19 Thread Frank Lanitz
Am 2012-10-15 23:13, schrieb John R Pierce: On 10/15/12 2:03 PM, Daniel Serodio (lists) wrote: John R Pierce wrote: On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote: 3) Estimate the size of the transaction log ** We've got no idea how to estimate this, need advice ** postgres doesn't ha

Re: [GENERAL] Help estimating database and WAL size

2012-10-19 Thread Jasen Betts
On 2012-10-15, Daniel Serodio (lists) wrote: >> >> OID is optional, IIRC PGXID is not > I hadn't heard of PGXID, I've just searched Google but found no > reference to this term except for this e-mail thread and some source > code. What is PGXID? Where can I learn more about hit? That was the wr

Re: [GENERAL] Help estimating database and WAL size

2012-10-15 Thread John R Pierce
On 10/15/12 2:03 PM, Daniel Serodio (lists) wrote: John R Pierce wrote: On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote: 3) Estimate the size of the transaction log ** We've got no idea how to estimate this, need advice ** postgres doesn't have a 'transaction log', it has the WAL (Wri

Re: [GENERAL] Help estimating database and WAL size

2012-10-15 Thread Daniel Serodio (lists)
John R Pierce wrote: On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote: 3) Estimate the size of the transaction log ** We've got no idea how to estimate this, need advice ** postgres doesn't have a 'transaction log', it has the WAL (Write-Ahead Logs). These are typically 16MB each. on

Re: [GENERAL] Help estimating database and WAL size

2012-10-15 Thread Daniel Serodio (lists)
Jasen Betts wrote: On 2012-10-08, Daniel Serodio (lists) wrote: We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We're a team of developers with low expertise on database administration, so we are doing research, reading man

Re: [GENERAL] Help estimating database and WAL size

2012-10-12 Thread John R Pierce
On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote: 3) Estimate the size of the transaction log ** We've got no idea how to estimate this, need advice ** postgres doesn't have a 'transaction log', it has the WAL (Write-Ahead Logs). These are typically 16MB each. on databases with a reall

Re: [GENERAL] Help estimating database and WAL size

2012-10-12 Thread Jasen Betts
On 2012-10-08, Daniel Serodio (lists) wrote: > We are preparing a PostgreSQL database for production usage and we need > to estimate the storage size for this database. We're a team of > developers with low expertise on database administration, so we are > doing research, reading manuals and us

Re: [GENERAL] Help estimating database and WAL size

2012-10-08 Thread Gavin Flower
On 09/10/12 09:39, Daniel Serodio (lists) wrote: We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We're a team of developers with low expertise on database administration, so we are doing research, reading manuals and using

[GENERAL] Help estimating database and WAL size

2012-10-08 Thread Daniel Serodio (lists)
We are preparing a PostgreSQL database for production usage and we need to estimate the storage size for this database. We're a team of developers with low expertise on database administration, so we are doing research, reading manuals and using our general IT knowledge to achieve this. We ha