Re: Some frustrations with admin tasks on PGSQL database

On 17/08/07, Martijn van Oosterhout <kleptog@svana.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!