> -
>
> a) vacuumdb - shell command
> b) VACUUM - SQL command
> c) autovacuum
> d) What is vacuum?
>
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subsc
---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
This could be a DNS related problem, if not the request itself, but the
connect, is
ext -
> >
> > - Show quoted text -
>
> Take a look at QueWeb from Queplix. It is mostly for Service/support
> and Customer Care, limited SFA, as Queplix does not focus on sales but
> rather on post-sales processes. It has an enterprise and OSS versions
> (GPL license). Enterpri
ption to anyone.)
>
> I would greatly appreciate your ideas and suggestions.
>
> FWIW, the script is currently run by my uid, but I could have it run
> by the postgres user, if that's of any help here.
>
> Thanks in advance!
>
> kj
>
> --
ld not find it.
>
> Thanks for any pointers.
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>
pgsql
> site such as "Fast Backward" and "Fast Forward"--these dont tell me
> anything--it would be much more useful to show me which section of the
> humongous and geeky manual I am currently in. The PHP manual is a
> fantastical layout to follow.
>
> My 0.02
0500 James Neff <[EMAIL PROTECTED]> thought long,
then sat down and wrote:
> I'm sorry to ask a stupid question, but how do I 'commit' the transactions?
>
> Thanks,
> James
>
>
>
> Frank Finner wrote:
> > When do you commit these inserts?
rt speed is slow. I think I may be able to type the
> data faster than what is being done by the java application on the third
> file.
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606Mail: [EMAIL PROTECTED]
Telefax: 0271 231
how do i fix it ?
>
> regards,
> KM
>
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606Mail: [EMAIL PROTECTED
ple have pointed out that perl is the best language to use
> while dealing with email parsing.
> We have the perl code ready to parse the email.
> Just wondering what would be the best method to deal with database
> (postgresql) calls from the perl code.
Use DBD::Pg, available at CPAN.
--
t; Christian Rengstl M.A.
> Klinik und Poliklinik für Innere Medizin II
> Kardiologie - Forschung
> Universitätsklinikum Regensburg
> B3 1.388
> Franz-Josef-Strauss-Allee 11
> 93053 Regensburg
> Tel.: +49-941-944-7230
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraß
(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
--
Frank Finner
Invenius - Lösungen mit
val. Otherwise you must
explicitly cast it like
SELECT play_length - play_seconds::interval...
Regards,
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606Mail: [EMAIL PROTECTED]
Telefax: 0271 231 8608Web: http://www.invenius.de
Key fi
On Sun, 04 Jun 2006 15:14:37 -0400 Tom Lane <[EMAIL PROTECTED]> thought long,
then sat down and wrote:
> Frank Finner <[EMAIL PROTECTED]> writes:
> > I run "./configure --with-perl --with-pam --with-openssl"
> > then "gmake"
> > and end up i
.4 on another NetBSD machine yet. On Linux (SuSE, RedHat
and CentOS) on other computers I got no problems at all.
Any ideas?
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606Mail: [EMAIL PROTECTED]
Telefax: 0271 231 8608Web: http://www.i
nly difference, at least from my point of view, is the method used and
> the extra disconnect(). But even so, the extra disconnect() is not really
> necessary.
I think the point is, that one has not to leave psql to get the new connection,
but simply use \c, while with perl / any programming
base.
>
> Thanks!!
> [:-)
> --
> View this message in context:
> http://www.nabble.com/Image-in-postgresql-7.3-t944227.html#a2446227
> Sent from the PostgreSQL - general forum at Nabble.com.
>
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
d WAL segment, but
> I am not anywhere close to recover to the last half hour. Has anyone mastered
> this?
>
> Per
>
> The script:
> @echo off
>
> @setlocal
>
> set PG_WAL_AREA="D:\PostgreSQL\8.0\data\pg_xlog"
> set CUR_WAL_AREA=""
>
> S
and thread.
My database became extremely slow, vacuum itself needed several hours instead
of several minutes, after doing some weeks of heavy inserting.
Vaccum obviously does not release all unused memory in 7.3.x.
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Te
works fine now.
Thanks for your help, it opened my eyes.
Regards, Frank
On Thu, 03 Mar 2005 12:14:53 -0500 Tom Lane <[EMAIL PROTECTED]> thought
long, then sat down and wrote:
> Frank Finner <[EMAIL PROTECTED]> writes:
> > error from Perl function: trusted Perl functi
install it as plperlu
"untrusted", the example above works correctly.
What is so bad with this function that I only can run it untrusted?
Regards, Frank
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606Mail: [EMAIL PROTECTED]
Telefa
- TIP 9: the planner will ignore
> your desire to choose an index scan if your
> joining column's datatypes do not match
--
Frank Finner
Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606Mail: [EMAIL PROTECTED]
Telefax:
data you dumped with pg_dump -a -D.
At least this worked for me rather smoothly from 7.1 to 7.3.
--
Frank Finner
Memory follows memory, memory defeats memory; some things are banished
only into the realms of our rich imaginings - but this does not mean
that they do not or cann
I really would like to know what they are going to do if somebodies´
MySQL-database crashes really hard (eg by CPU failure) and comes back with
inconsistent state. Do they agree to be liable for that, because they certified
it?
Comparing MySQL with DB2 is IMHO quite funny. Like comparing pocket ca
Hi,
shared_buffers seems quite low for a server to me. For best performance, you
should read and follow the optimisation articles on
http://techdocs.postgresql.org/.
Regards, Frank
On Wed, 26 May 2004 11:26:30 -0400 (VET) "Mario Soto"
<[EMAIL PROTECTED]> sat down, thought long and then wrote:
On Tue, 27 Apr 2004 19:08:12 +0200 Frank Finner <[EMAIL PROTECTED]> sat down,
thought long and then wrote:
> After having installed the SuSE shipped PostgreSQL packages, you simply have
> to start the database as root with "rcpostgresql start". If the database is
> not
On Mon, 26 Apr 2004 10:22:36 -0700 Andrew Ayers <[EMAIL PROTECTED]> sat down,
thought long and then wrote:
> Bill Moran wrote:
> > Stephen Salbod wrote:
> >
> >> My background is Windows and I just switched, yesterday to, Suse Linux
> >> Professional 9.0. And I have a class project due Monday, w
On Sun, 28 Mar 2004 20:08:11 +0700 David Garamond <[EMAIL PROTECTED]> sat down, thought
long and then wrote:
> I for one vote for win32 users having their own list as soon as
> possible. I predict three things:
>
> 1) there will be *lots* of them coming to -general (instead of to -novice);
> 2)
On Sun, 28 Mar 2004 14:24:15 +0900 Alex <[EMAIL PROTECTED]> sat down, thought long and
then
wrote:
> Hi,
> what is the recommended way to run multiple databases under postgres.
>
> In MySQL it is rather simple to give different users or websites their
> own database with all the access rights.
Hi,
from my point of view (and according to my experiences) I wouldn´t recommend the use
of MySQL
between Access and PostgreSQL. It has a somewhat similiar, although subtle different
language
compared to PostgreSQL, and if one uses it, he will get used to that and going on to
PostgreSQL will
be
Hi,
surely you are right. I´m still using 7.2.3 as production database, so I
have no experience with .pgpass. Where to put .pgpass if you use pg_dump
from a PHP script and the database user is not a system user?
Greetings,
Frank Finner
On Fri, 25 Jul 2003 17:17:26 -0400 Andrew Sullivan
31 matches
Mail list logo
