Re: SELECT * FROM <table> LIMIT 1; is really slow - Mailing list pgsql-hackers : Postgres Professional

Re: SELECT * FROM LIMIT 1; is really slow - Mailing list pgsql-hackers

From

Zeugswetter Andreas SB SD

Subject

Re: SELECT * FROM LIMIT 1; is really slow

Date	May 27, 2004 08:37:27
Msg-id	46C15C39FEB2C44BA555E356FBCD6FA40184D0E9@m0114.s-mxs.net Whole thread Raw
List	pgsql-hackers

Tree view

> What would be useful for that (as of 7.5) is a dummy ALTER TABLE TYPE,
> viz
>
>     ALTER TABLE tab ALTER COLUMN col TYPE same-type-it-already-has

I think we should add special syntax for this purpose, since I would like to
(or someone else later on) see all possible cases of "alter column" short
circuited.

The syntax I would see fit is something like:
ALTER TABLE tab [MOVE] TABLESPACE xy;

For the above special case the tablespace would be the same as before.

Andreas

pgsql-hackers by date:

From: Stephan Szabo
Date: 27 May 2004, 06:24:49
Subject: Re: Nested xacts: looking for testers and review

From: Andreas Pflug
Date: 27 May 2004, 09:30:28
Subject: Re: tablespaces and DB administration

Previous

Next