Generally, we'll need schema and query in question.
Also, have you run a vacuum analyze on your data recently?
On Fri, 9 Mar 2001, KoPra Workshop wrote:
> I'm having problem in postgresql performance (response query result)
> when installed on
> Compaq Proliant ML350 - RAM 256 MB - No Mirror SCSI RAID
>
> I done set postmaster config with [ -B 256 -N 128 -i -o -F -S4096]
> Partition "/data" size 3 GB
>
> Any body can advice here....? or request other information to analyze...?
>
> Eko Pranoto
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>