Re: [GENERAL] Give me a HINT or I'll got crazy ;)

2009-10-09 Thread Wojciech Strzałka
o the right thing. > But it seems to think there will be thousands of joins for each one... > regards, tom lane -- Pozdrowienia, Wojciech Strzałka -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Feature proposal

2010-08-25 Thread Wojciech Strzałka
improve it? > The most obvious would be to turn fsync off, sychronous_commit off, > increase work_mem, increase checkpoint_timeout, increase wal_segments. > JD >> >> >> -- Pozdrowienia, Wojciech Strzałka -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Feature proposal

2010-08-30 Thread Wojciech Strzałka
e boost. You need to have WAL archiving turned off > though. > Also, if you do that, perhaps there's no point in turning off fsync and > synch_commit because an fsync will be done only once when the copy is > complete. -- Pozdrowienia, Wojciech Strzałka -- Sent via pgsq

Re: [GENERAL] Stats collector eats my CPU

2008-10-08 Thread Wojciech Strzałka
gest I know > of. However, I've seen partitioned designs with more than 100,000 > tables. 250,000 is a lot for Postgres, but we should be designing > Postgres to cope with up to 1,000,000 tables or partitions. There's lots > of data out there and if it doesn't come to us it will go elsewhere. -- Pozdrowienia, Wojciech Strzałka -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Stats collector eats my CPU

2008-10-08 Thread Wojciech Strzałka
effect of uptime which is about half a year now. > 2008/10/8 Wojciech Strzałka <[EMAIL PROTECTED]>: >> >> For clarification 250k is total relation count. >> There is 85k plain tables + 45k toasts. >> >> Except stats collector overload, the cluster works fine (

Re: [GENERAL] Problem installing PG9.1 using yum

2011-12-12 Thread Wojciech Strzałka
> On Sun, 2011-12-11 at 09:17 -0800, wstrzalka wrote: >> Error: Package postgresql90-devel needs postgresql90 = >> 9.0.1-4PGDG.rhel5, this is not available. > Please remove postgresql90-devel.i386 prior to installation. > We don't push -devel.i386 packages to x86_64 repos anymore. > Regards,

Re: [GENERAL] Problem installing PG9.1 using yum

2011-12-12 Thread Wojciech Strzałka
> Please also remove postgresql90-libs.i386 Thanks a lot. Works perfect now. Best regards Wojtek -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general