someone asked the same question here not so long time ago
Sorry about that, I searched my personal archive, which goes back until oct
2006, and google, before I asked.
Must have missed it then.
Thx for the insight!
WBL
--
Patriotism is the conviction that your country is superior to all
What happens to indexes on a table that is TRUNCATEd?
They are truncated too.
From the manual:
Furthermore, [truncate] reclaims disk space immediately, rather than
requiring a subsequent VACUUM operation.
Does this go for indexes too?
Thx,
WBL
--
Patriotism is the conviction that your
On Wed, Dec 17, 2008 at 11:37 AM, Willy-Bas Loos willy...@gmail.com wrote:
What happens to indexes on a table that is TRUNCATEd?
They are truncated too.
From the manual:
Furthermore, [truncate] reclaims disk space immediately, rather than
requiring a subsequent VACUUM operation.
Does this go
What happens to indexes on a table that is TRUNCATEd?
They are truncated too.
From the manual:
Furthermore, [truncate] reclaims disk space immediately, rather than
requiring a subsequent VACUUM operation.
Does this go for indexes too?
Thx,
WBL
--
Patriotism is the conviction that your country
On Wed, Dec 17, 2008 at 4:44 PM, Willy-Bas Loos willy...@gmail.com wrote:
someone asked the same question here not so long time ago
Sorry about that, I searched my personal archive, which goes back until oct
2006, and google, before I asked.
Must have missed it then.
must have been either irc
Willy-Bas Loos escribió:
What happens to indexes on a table that is TRUNCATEd?
They are truncated too.
From the manual:
Furthermore, [truncate] reclaims disk space immediately, rather than
requiring a subsequent VACUUM operation.
Does this go for indexes too?
Yes.
--
Alvaro Herrera
Willy-Bas Loos escribió:
What happens to indexes on a table that is TRUNCATEd?
They are truncated too.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list
What happens to indexes on a table that is TRUNCATEd?
WBL
--
Patriotism is the conviction that your country is superior to all others
because you were born in it. -- George Bernard Shaw