I tried to add up records 2 different ways:
1. using command [copy messageinfo (user_id, receivedtime, filename,
sendersstring, subject,
hasattachments, groupmsg, msgsize, version ) FROM '/meridtemp/messageinfo.dat';]
from psql
2. using simple INSERT INTO messageinfo ( user_id ) V
Copy from .. works fine for 1000 records to load. For data set of 6 records I
could never get
it finish. And I'm planing to reload 1000,000 records.
So there is a limit somewhere between 1,000 & 60,000 since it starts working slower.
The only
question for me left is. What config parameter(s)
messageinfo WHERE user_id = 2::bigint and msgstatus
=
0::smallint;
--- "Joshua D. Drake" <[EMAIL PROTECTED]> wrote:
> Artimenko Igor wrote:
> > I could force Postgres to use the best index by removing condition "msgstatus =
> > CAST( 0 AS
> > smallint );&
