hanks,
Ganbold
Lennin Caro wrote:
use REINDEX
REINDEX ip_dst_idx
OR
REINDEX table_name
http://www.postgresql.org/docs/8.3/static/sql-reindex.html
tell us the result
thank
--- On *Fri, 6/27/08, Ganbold /<[EMAIL PROTECTED]>/* wrote:
From: Ganbold <[EMAIL PROTECTED]>
Subject
1921693 row versions
HINT: Rebuild the index with REINDEX.
ERROR: could not read block 988 of relation 1663/16384/16472:
Input/output error
snort=# reindex index ip_src_idx;
ERROR: concurrent insert in progress
How to solve this problem? Is there any other method fixing the index?
thanks
Hi,
David Fetter wrote:
On Mon, Oct 30, 2006 at 09:10:36AM -0500, Chander Ganesan wrote:
Ganbold wrote:
Hi,
I'm new to postgresql and I'm looking for references and books. We are
usually coding in php/C.
Can somebody recommend me good books wh
least DB (tables, indexes, queries)?
Are there any tools that can convert php functions and database from
mysql to postgresql?
thanks in advance,
Ganbold
---(end of broadcast)---
TIP 6: explain analyze is your friend