De : mailto:[EMAIL PROTECTED]
> Cyril VELTER wrote:
> >
> > Is length() supposed to return the very high length in case of
> > corruption
?
>
> You'd have thought it would. The odd thing (if it is data corruption) is
> that you would expect to see s
De : mailto:[EMAIL PROTECTED]
> "Cyril VELTER" <[EMAIL PROTECTED]> writes:
> > The server have 4G of ram. But doing a search in the source code it
> > does
not
> > seem that these values are used during a copy operation.
>
> They aren't. T
De : mailto:[EMAIL PROTECTED]
> Cyril VELTER wrote:
> >
> > maintenance_work_mem and work_mem are set to their default value (16M /
1M).
> > Does Copy use any of these values ? The doc only state sort operations for
> > work_mem and vacuum / create index /
C locale. This table have several fields which can be pretty
large (the biggest row is ~35MB).
Any ideas ?
Cyril VELTER
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
De : mailto:[EMAIL PROTECTED]
> Cyril VELTER wrote:
> > OK, I've the results of my tests :
> >
> > With the previous code, then message "SOCKERROR" is printed 5 times
> > during
the
> > whole process (100 Gb dump import with psql). The
> Cyril VELTER wrote:
> >
> >>> Cyril VELTER wrote:
> >>>> Searching the source files, it seems the error message is generated in
> >>>> port/win32/socket.c line 594.
> >>> Right, but the important thing is which path down to t
> > Cyril VELTER wrote:
>
> >
> > > Searching the source files, it seems the error message is generated in
> > > port/win32/socket.c line 594.
> >
> > Right, but the important thing is which path down to that function is it
> >
> Cyril VELTER wrote:
> >> Cyril VELTER wrote:
> >>> No I'm not. It's not even complied in the server nor in the pg_dump
> > binary.
> >>> The server is built on windows using MSYS simply with ./configure &&
make
> > a
> Cyril VELTER wrote:
> > No I'm not. It's not even complied in the server nor in the pg_dump
binary.
> >
> > The server is built on windows using MSYS simply with ./configure &&
> > make
all
> > && make install
> >
> [EMAIL PROTECTED] wrote :
> Cyril VELTER wrote:
> >
> > I'm trying to upgrade a pretty big database (60G) from postgres 8.0 to
> > postgres 8.2 on windows 2000 Server (both version running on the same
machine
> > on different ports). During the migratio
I'm trying to upgrade a pretty big database (60G) from postgres 8.0 to
postgres 8.2 on windows 2000 Server (both version running on the same machine
on different ports). During the migration process, I always get an error at
some point (never the same) :
LOG: could not receive
From: "Doug McNaught" <[EMAIL PROTECTED]>
> "Cyril VELTER" <[EMAIL PROTECTED]> writes:
>
> > I'm trying to dump a database from a 7.1.3 server to a 7.4.2 one.
> >
> > It doesn't works because of difference in COP
I'm converting an application to use the V3 protocol features in the 7.4
libpq. As I need to make a design choice regarding the use of prepared
statements, I'm wondering what ressources does a prepared statement use on
the server ? If I need to create several hundred in each backend, is there a
big
13 matches
Mail list logo
