Gregory Stark wrote:
> I have a question about what would happen for a transaction running a command
> like COPY FROM. Is it possible it would manage to arrange to have no live
> snapshots at all? So it would have no impact on concurrent VACUUMs? What about
> something running a large pg_restore?

Interesting idea.  If the table had triggers, it would need a snapshot,
but if not, yea, that is certainly possible.


> "Tom Lane" <[EMAIL PROTECTED]> writes:
> > On the whole though I think we should let this idea go till 8.4; 
> I tend to agree but for a different reason. I think it's something that will
> open the doors for a lot of new ideas. If we put it in CVS HEAD early in 8.4 I
> think (or hope at any rate) we'll think of at least a few new things we can do
> with the new more precise information it exposes.
> Just as an example, if you find you have no live snapshots can you throw out
> the combocid hash? Any tuple you find with a combocid that's been discarded
> that way must predate your current scan and therefore is deleted for you.
> -- 
>   Gregory Stark
>   EnterpriseDB
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?

  Bruce Momjian  <[EMAIL PROTECTED]>

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to