Hi,
fillfactor affects 'update' statements or also has affects for
'insert' and 'delete'?
Thanks,
Sia
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED
Hi,
Designing my application, I was wondering if having my primary keys
(to be indexed) with VARCHAR brings performance down significantly? My
own test didn't show much difference. Thinking about it though, I'd
guess Integer Indexing should be much quicker and efficient.
I'd appreciate all commen
Hi,
How can I have my table clustered as records are being insert/updated
(per transaction).
I tried doing so with creating an index using pgAdmin III, and it
generated the following SQL:
CREATE INDEX someindex ON mytable (m2);
ALTER TABLE mytable CLUSTER ON someindex;
Now, above DID NOT cluste
Some pointers could help. & any arguments pro/against saving bin data
in db?
Thanks,
Sia
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Hi,
I see people use postgreSQL for storing their binary data including
images, etc. Here are a few questions I would very much like to have
expert opinions on:
- Is it not faster / more efficient to store binary data using file
system and let DB keep the path?
- I know of only one way to interac
