Re: Some frustrations with admin tasks on PGSQL database

On 17/08/07, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> On Fri, Aug 17, 2007 at 07:49:08PM +0800, Phoenix Kiula wrote:
> > However, I am a little frustrated by the amount of time PGSQL takes to
> > complete tasks. Just to accommodate these tasks, my conf file has the
> > following:
> >
> > autovacuum = off
> > wal_buffers=64
> > checkpoint_segments=1000
> > checkpoint_timeout=900
> > fsync = off
> > maintenance_work_mem = 128MB
>
> I note you did not give either the shared_buffers setting or the
> work_mem setting, both of which would have a major impact on your
> problem.

Oh, sorry, here are the rest of them:

max_connections = 250
shared_buffers = 60000
effective_cache_size = 60000
work_mem = 60000
max_fsm_relations = 1500
max_fsm_pages = 80000
sort_mem = 16348
temp_buffers = 4096
authentication_timeout = 10s
ssl = off

Are these too low?

>
> How big is the actual table itself (in bytes).
>

Where should I find this?

I tried "/usr/lib/pgsql/data" and "/var/lib/pgsql/data" but there is
no folder that seems to show the data files.

TIA!