Hello,
I'm using postgresql 7.4.2, and I have this view:
slooze=# \d userpictures2
Vue «public.userpictures2»
Colonne | Type | Modificateurs
-+--+---
pictureid | integer |
rollid | character v
Laurent Martelli <[EMAIL PROTECTED]> writes:
> The pictures table is scanned, but it's not needed.
Yes it is. For example, if pictures is empty then the view yields
zero rows. Omitting the join to pictures could give a different result.
regards, tom lane
---
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Laurent Martelli <[EMAIL PROTECTED]> writes:
>> The pictures table is scanned, but it's not needed.
Tom> Yes it is. For example, if pictures is empty then the view
Tom> yields zero rows. Omitting the join to pictures could give a
I've got a simple database (no indices, 6 columns) that I need
to write data quickly into through JDBC connections from
multiple such connections simultaneously in a distributed
environment. (This is going to be a message logging service
for software generated messages.)
Using a PreparedStatemen
Have you tried VACUUM ANALYZE at least one a day?
Regards
On Fri, 20 Feb 2004 [EMAIL PROTECTED] wrote:
> Date: Fri, 20 Feb 2004 14:46:15 +0530
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: [PERFORM] Slow in morning hours
>
> Hi All,
>
> I am using Linux 7.2
On Fri, 20 Feb 2004, Sean Shanny wrote:
> max_connections = 100
>
> # - Memory -
>
> shared_buffers = 16000 # min 16, at least max_connections*2,
> 8KB each
> sort_mem = 256000 # min 64, size in KB
You might wanna drop sort_mem somewhat and just set it during your impor
