| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | KoPra Workshop <kopraworkshop(at)telkom(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Optimizing Advice...Now please |
| Date: | 2001-03-09 19:18:11 |
| Message-ID: | Pine.BSF.4.21.0103091117390.81399-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)postgresql(dot)org)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | justin.lipshitz | 2001-03-09 21:25:21 | Permissions on Functions |
| Previous Message | KoPra Workshop | 2001-03-09 16:44:32 | Optimizing Advice...Now please |