"David Busby" <[EMAIL PROTECTED]> writes:
> List,
> Which of the may Perl Modules on CPAN should I use for PostgreSQL. I'd
> prefer the fastest/most up to date module. Which is it or do I have to dig
> through them all?
The latest DBD::Pg (which I think is now hosted on
gborg.postgresql.org
"Chris Stokes" <[EMAIL PROTECTED]> writes:
> >The REINDEX is needed because VACUUM doesn't free up index space in
> >some circumstances. 7.4 (currently in late beta) will fix this.
>
> Sorry Doug,
>
> Yes I am doing a vacuum regularly - in fact, when the speed of the
> DB becomes slower, the va
"Chris Stokes" <[EMAIL PROTECTED]> writes:
> WE currently use PG for the local database on our POS workstations
> in shops. Data is then extracted and sent back to head office. Also
> product updates etc are regularly sent to the shops. I have noticed
> over time that the shop PG databases get slo
Hi all,
WE currently use PG for the local database on our POS workstations in shops. Data is
then extracted and sent back to head office. Also product updates etc are regularly
sent to the shops. I have noticed over time that the shop PG databases get slower and
slower. If I do a pg_dump, recre
Folks,
Stefano is our project's Italian translator. But he's feeling a little
overwhelmed lately. I'd desperately like to find someone to share the
responsibility of English-->Italian translation with him.
Please e-mail me ASAP; even if you can only help out on a one-time basis, this
week,
On Thu, 30 Oct 2003, Ken Guest wrote:
> Folks,
> I have a question or two regarding PHP and Postgres on the issue of
> speed:
> 1.Is the semicolon at the end of SQL superflous when sent to Postgres?
> Should it make much of a difference if I removed it?
Yes, you can get rid of it. No, it won
On Thu, 30 Oct 2003, David Green wrote:
>
> On Thu, 30 Oct 2003, Scott Marlowe wrote:
>
> > "It's far more likely that optimizing your SQL queries will yield the
> > greatest increase in performance. Things like replacing "select max(id)
> > from table" with "select id from table order by id de
> > In the following situation:
> >
> > You do a large transaction where lots of rows are update
> > All of your tables/indexes cached in memory
> >
> > When are the updated rows written out to disk? When they are updated
inside
> > the transaction, or when the transaction is completed?
>
> The da
"Dave Weaver" <[EMAIL PROTECTED]> writes:
> Is the upgrade likely to make a difference?
I'm not sure if it would help for this specific query, but in general
each major PG release has useful performance improvements over the
previous one.
What I'm wondering about is an index-bloat problem (see th
On Thu, 30 Oct 2003, Scott Marlowe wrote:
> "It's far more likely that optimizing your SQL queries will yield the
> greatest increase in performance. Things like replacing "select max(id)
> from table" with "select id from table order by id desc limit 1" etc..."
When I first read this I was su
On Thu, 30 Oct 2003, Dave Weaver wrote:
> Jeff wrote:
> > Dave Weaver wrote:
> > > For instance:
> > > SELECT station, air_temp FROM obs
> > > WHERE station = 'EGBB'
> > > AND valid_time > '28/8/03 00:00'
> > > AND valid_time < '28/10/03 00:00'
> > >
> > > takes 4 mi
Tino Wildenhain wrote:
Hi,
Alexander Deruwe schrieb:
Hey,
I was wondering if it is possible to send email from within PL/pgsql.
I'd like to do this to avoid code duplication in multiple frontends.
Can this be done somehow? Or do I have to write a C function for this
purpose? If so, how does on
On Thursday 30 October 2003 06:38, scott.marlowe wrote:
> On Wed, 29 Oct 2003, Scott Chapman wrote:
> > In my further discussion with Andrew offline, we came up with a joint
> > suggestion to have PostgreSQL do automatic auditing. This would be VERY
> > NICE, imho. Any input?
> >
> > Scott wrote:
On Wed, 29 Oct 2003, Allen Landsidel wrote:
> Here's maybe a silly question, but I haven't seen it asked or answered
> so.. For those settings in the .conf file that say "this doesn't take
> effect until the database is restarted".. does that mean that "pg_ctl
> reload" also does not reload th
On Wed, 29 Oct 2003, Scott Chapman wrote:
> In my further discussion with Andrew offline, we came up with a joint
> suggestion to have PostgreSQL do automatic auditing. This would be VERY
> NICE, imho. Any input?
>
> Scott wrote:
> > It seems like it would be nice if you could flip a toggle o
Harald Fuchs <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> 7.4's pg_dump has an option to dump the contents of just one schema.
> The pg_dump manpage of beta4 does not include this option,
Sure it does:
-n namespace
--schema=schema
Dump the contents of schema only.
Tom Lane wrote:
> Harald Fuchs <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >> 7.4's pg_dump has an option to dump the contents of just one schema.
>
> > The pg_dump manpage of beta4 does not include this option,
>
> Sure it does:
>
> -n namespace
> --schema=schema
>
>
On Thu, 30 Oct 2003, Scott Chapman wrote:
> On Thursday 30 October 2003 06:38, scott.marlowe wrote:
> > On Wed, 29 Oct 2003, Scott Chapman wrote:
> > > In my further discussion with Andrew offline, we came up with a joint
> > > suggestion to have PostgreSQL do automatic auditing. This would be VE
> > For instance:
> > SELECT station, air_temp FROM obs
> > WHERE station = 'EGBB'
> > AND valid_time > '28/8/03 00:00'
> > AND valid_time < '28/10/03 00:00'
> >
> > takes 4 mins 32 secs.
How many rows should that return?
[explain analyze will tell you that]
and wh
Jeff wrote:
> Dave Weaver wrote:
> > For instance:
> > SELECT station, air_temp FROM obs
> > WHERE station = 'EGBB'
> > AND valid_time > '28/8/03 00:00'
> > AND valid_time < '28/10/03 00:00'
> >
> > takes 4 mins 32 secs.
>
> How many rows should that return?
> [expla
Hi,
WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able to backup without passwords ?
Thanks.
Jeff.
---(end of broadcast)---
21 matches
Mail list logo
