Re: DBI, postgresql and large table
- From: chas.owens@xxxxxxxxx (Chas Owens)
- Date: Wed, 27 Jun 2007 16:37:17 -0400
On 6/27/07, Andrej Kastrin <andrej.kastrin@xxxxxxxx> wrote:
Dear all,
I need to process postgresql table with DBI module. The script below
works well for small tables, but when I want to process larger tables
(100000 rows) out-of-memory occurs.
Any suggestion? Thanks in advance,
Andrej
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect("DBI:Pg:dbname=medline;host=localhost",
"postgres", "secret", {'RaiseError' => 1});
my $sth = $dbh->prepare("SELECT text_a, text_b FROM tmp_table");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
my $field_a = $ref->{'text_a'};
my $field_b = $ref->{'text_b'};
print "$field_a \t $field_b\n";
}
* When does it fail and what is the exact error message?
* Have you tried to execute this command in an SQL editor (psql if I
remember correctly)?
* How much memory do you have on that box?
.
- Follow-Ups:
- Re: DBI, postgresql and large table
- From: Andrej Kastrin
- Re: DBI, postgresql and large table
- References:
- DBI, postgresql and large table
- From: Andrej Kastrin
- DBI, postgresql and large table
- Prev by Date: DBI, postgresql and large table
- Next by Date: Re: String Manipulation
- Previous by thread: DBI, postgresql and large table
- Next by thread: Re: DBI, postgresql and large table
- Index(es):
Relevant Pages
|
|
