| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Daniel Kalchev <daniel(at)digsys(dot)bg> |
| Cc: | Ryan Bradetich <rbradetich(at)uswest(dot)net>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Questions about indexes? |
| Date: | 2003-02-17 12:25:14 |
| Message-ID: | 20030217202431.Y6345-100000@houston.familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> I ended up with few only indexes on the operations table, because the
> processes that fill it up do minimal lookups to see if data is already in the
> table, if not do inserts. Then at regular intervals, the table is cleaned up -
> that is, a process to remove the duplicate is run. This unfortunately costs
> OIDs, but I found no other reasonable way to do the fast inserts. Perhaps the
> best way is to create the table without OIDs (but wouldn't this still waste
> OIDs?) use COPY and then clean afterwards?
No, WITHOUT OIDS is implemented specifically to not waste OIDs.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2003-02-17 12:44:45 | Re: client_encoding directive is ignored in |
| Previous Message | Andreas Schmitz | 2003-02-17 12:23:36 | Re: Still a bug in the VACUUM ??? !!! |