Postgres Pro
Downloads
Home   >   mailing lists

Will something bad happen if I put index on xmin ? - Mailing list pgsql-hackers

From Hannu Krosing
Subject Will something bad happen if I put index on xmin ?
Date
Msg-id 3AE423B6.10104@tm.ee
Whole thread Raw
Responses Re: Will something bad happen if I put index on xmin ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Hi,

I'm about to write a simple one-way replication script relying on xmin
and would like to speed up things by putting an index on it.

So I have a few questions:

1. Will something bad happen if I put index on xmin ?

2. Is it just a bad idea to do it that way ?   (there will be no deletes, just mainly inserts and some updates)


------------
Hannu

pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: RFC: planner statistics in 7.2
Next
From: Chad La Joie
Date:
Subject: 7.2 feature request