> Not sure. Does /contrib/pg_resetxlog help? Try running it.
That would have helped quite a bit. It's too late now, but it's
something I'll remember for next time. Thanks.
--Nate
---(end of broadcast)---
TIP 1: subscribe and unsubscrib
Nathan Mueller wrote:
> I had a hardware error on my server and lost the WAL files. I can
> restore my data, but because of the size of the database that'll take at
> least 12 hours. Is there any way to start the server without the
> transaction logs?
However, once you use /contrib/pg_resetxlog
Nathan Mueller wrote:
> I had a hardware error on my server and lost the WAL files. I can
> restore my data, but because of the size of the database that'll take at
> least 12 hours. Is there any way to start the server without the
> transaction logs?
Not sure. Does /contrib/pg_resetxlog help?
On Fri, 7 Jun 2002 16:44:16 -0500
"Nick Fankhauser" <[EMAIL PROTECTED]> wrote:
> > Is there some indexing strategy or backup regimen I could implement
> > that would make all this better?
>
> I don't understand the question- are you asking how to make databases
> created in access run better on p
In the only other creds failure I can remember on Linux, it was caused
by someone updating their partially system headers, but not completely.
---
Niclas Gustafsson wrote:
> > Niclas Gustafsson <[EMAIL PROTECTED]> writes:
>
> I have a Postgres admin question.
...
> Is there some indexing strategy or backup regimen I could implement that
> would make all this better?
Tim-
I don't understand the question- are you asking how to make databases
created in access run better on postgresql, or how to move them to
postgres
Ferdinand,
The results are not bad at all. But your test seems
flawed to me. And you would get the same result
regardles of database engine used.
You do 10,000 loops and each loop has 2 calls to the
DBI module. So if your network roundtrip is really
exactly 1ms that would put you at 20,000ms
On Fri, 7 Jun 2002 09:37:08 -0500
"Ross J. Reedstrom" <[EMAIL PROTECTED]> wrote:
> > SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') +
> > CGCCli As Coluna FROM Clientes WHERE RazaoSocial Like '%A%'
>
> This looks like some other dialect of SQL, not SQL92 (nor PostGreSQL).
. .
On Thu, 2002-06-06 at 21:43, Robson Martins wrote:
> What err ???
>
> SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna
>FROM Clientes WHERE RazaoSocial Like '%A%'
^^
You should probably be using CO
Try:
SELECT RazaoSocial || ' - ' || coalesce(Bairro || ' ','') || CGCCli As
Coluna FROM Clientes WHERE RazaoSocial Like '%A%';
>SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli
As Coluna FROM
>Clientes WHERE RazaoSocial Like '%A%'
Regards,
Nick
On Thu, 6 Jun 2002 17:43:28 -0300
"Robson Martins" <[EMAIL PROTECTED]> wrote:
> What err ???
>
> SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna
>FROM Clientes WHERE RazaoSocial Like '%A%'
>
Uh, there is no error in MS Access, but are two errors in PG: "+
On Thu, Jun 06, 2002 at 05:43:28PM -0300, Robson Martins wrote:
> What err ???
>
> SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna
>FROM Clientes WHERE RazaoSocial Like '%A%'
This looks like some other dialect of SQL, not SQL92 (nor PostGreSQL).
I _think_ yo
On Thu, 6 Jun 2002, Robson Martins wrote:
> What err ???
>
> SELECT RazaoSocial + ' - ' + Iif(Bairro Is Null,'',Bairro + ' ') + CGCCli As Coluna
>FROM Clientes WHERE RazaoSocial Like '%A%'
Messages like this are better sent to pgsql-general or pgsql-sql, by the
way.
Two problems:
. Strings ar
How much data is 20,000 lines? 20KB? 100MB? You might do well to just
process this in memory and then just COPY the right data to the table.
This gets away from doing the SELECT/INSERT/SELECT/INSERT thing which is
going to be painful for batch jobs.
See, the thing is that on every insert the inde
Oh ok. So I was thinking of the way that sequences cut across transactions
and I misinterpreted it. Thanks for the clarification.
Joshua b. Jore ; http://www.greentechnologist.org ; 1121 1233 1311 200
1201 1302 1211 200 1201 1303 200 1300 1233 1313 1211 1302 1212 1311 1230
200 1201 1303 200 1321
What err ???
SELECT RazaoSocial + ' - ' + Iif(Bairro Is
Null,'',Bairro + ' ') + CGCCli As Coluna FROM Clientes WHERE RazaoSocial Like
'%A%'
Hi,
Does anyone have any tips to improve the network preformance op Postgres ?
To test the preformance i've done a little test using the perlmodule DBI.
The ping last 1 ms and the computers are identical.
The test script:
#!/usr/bin/perl
use DBI;
my $connectTo = "dbi:Pg:dbname=testdb;host=obe
17 matches
Mail list logo
