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
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
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
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
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 (
> 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,
> 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