"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Sat, Sep 24, 2005 at 07:19:10PM -0400, Tom Lane wrote:
>> Currently, when a tuple is reclaimed by VACUUM, we just mark its item
>> pointer as unused (and hence recyclable). I think it might be safe to
>> decrease pd_lower if there are unused pointers
Sterpu Victor <[EMAIL PROTECTED]> writes:
> I use postgresql 7.4.8.
> I need te delete and recreate a database very ofent, because I do some
> tests in it.
> After a few months the command createdb becamed very slow.
> How can I make it go fast again?
The only explanation that comes to mind is th
My guess is you need to vacuum. Try a vacuumdb -a.
On Sun, Sep 25, 2005 at 03:46:38AM +0300, Sterpu Victor wrote:
> I use postgresql 7.4.8.
> I need te delete and recreate a database very ofent, because I do some
> tests in it.
> After a few months the command createdb becamed very slow.
>
> How
You really should look at something like Fedora Core or Ubuntu
if you want FREE. If you don't mind paying the SuSE is a good choice.
If you want RHE look and feel but don't want to pay, look at CentOS.
Sincerely,
Joshua D. Drake
Just as a FYI, you don't have to pay for Suse anymore, unl
Tom Lane wrote:
> Bruce Momjian writes:
> > Daniel Verite wrote:
> >> So it looks like the problem would be DLL-related?
>
> > Is there a problem with a DLL writing to a file descriptor opened by
> > application code? I would think not, but perhaps.
>
> Hmm malloc/free are broken in exactl
Joshua D. Drake wrote:
Bizarre.
Question:
Does the problem happen when you just type psql?
What if you pass the host option? e.g; psql -h 127.0.0.1
What type of auth are you running?
Don't use Gentoo? Seriously, that distribution is completely
unsupportable because no one else has the f
I use postgresql 7.4.8.
I need te delete and recreate a database very ofent, because I do some
tests in it.
After a few months the command createdb becamed very slow.
How can I make it go fast again?
Thank you.
---(end of broadcast)---
TIP 3: Ha
On Sat, Sep 24, 2005 at 07:19:10PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > I can't seem to find info about this in the docs, or on the web.
>
> http://developer.postgresql.org/docs/postgres/storage-page-layout.html
>
> Currently, when a tuple is reclaimed by VACUUM
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> I can't seem to find info about this in the docs, or on the web.
http://developer.postgresql.org/docs/postgres/storage-page-layout.html
Currently, when a tuple is reclaimed by VACUUM, we just mark its item
pointer as unused (and hence recyclable). I t
I can't seem to find info about this in the docs, or on the web.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end
Just remember the first rule of performance tuning: don't.
Unless you *know* having the dead rows will be an issue, you will almost
certainly be best off going the simple, straightforward route.
On Fri, Sep 23, 2005 at 10:49:00AM -0500, Scott Marlowe wrote:
> On Fri, 2005-09-23 at 05:51, Yonatan
Tom Lane wrote:
Hmm. Now that I look at it again, that message implies that something
sent SIGTERM to the backend. You need to figure out where that signal
is coming from and why. ...
is it possible that you've started your postmaster with finite limits
on process runtime? What is the platfo
=?ISO-8859-1?Q?Poul_M=F8ller_Hansen?= <[EMAIL PROTECTED]> writes:
>> Is it possible that you've got DNS timeouts happening or something
>> like that? Though I don't think PG does reverse DNS lookups,
>> especially not by default.
> DNS was also my first thought, but the connection isn't logged s
Is it possible that you've got DNS timeouts happening or something
like that? Though I don't think PG does reverse DNS lookups,
especially not by default.
Watching the connection process with 'tcpdump' to see where the stall
happens might be informative.
-Doug
DNS was also my first thought
Tom Lane wrote:
> Don't use Gentoo? Seriously, that distribution is completely
> unsupportable because no one else has the faintest idea what you are
> really running. You've probably got some system component that is
> either broken in itself or incompatible with some other component,
> but ther
Tom Lane wrote:
"Justin R. Smith" <[EMAIL PROTECTED]> writes:
I'm running postgresql 8.03 under Gentoo Linux and find that all actions
take at least a MINUTE (even dropdb and createdb). During this time, the
posgres account is locked up to the extent that one cannot even su to
it. (The su
Bizarre.
Question:
Does the problem happen when you just type psql?
What if you pass the host option? e.g; psql -h 127.0.0.1
What type of auth are you running?
Don't use Gentoo? Seriously, that distribution is completely
unsupportable because no one else has the faintest idea what you are
"Justin R. Smith" <[EMAIL PROTECTED]> writes:
> I'm running postgresql 8.03 under Gentoo Linux and find that all actions
> take at least a MINUTE (even dropdb and createdb). During this time, the
> posgres account is locked up to the extent that one cannot even su to
> it. (The su suceeds when t
Ron Mayer <[EMAIL PROTECTED]> writes:
> Fails the same way in each case. It was doing a HashAggregate last time; but
> I just reproduced it now with a GroupAggregate.
> fli=# explain analyze select ext_doc_id,strcat_agg(nam)||+strcat_agg(val)
> from facet_raw group by ext_doc_id;
> FATAL: termi
=?iso-8859-1?q?Mart=EDn_Marqu=E9s?= writes:
> I can't create any VIEW at all. I'm using the latest debian testing
> PostgreSQL
> (8.0.3):
Maybe you got a corrupt download?
regards, tom lane
---(end of broadcast)---
TIP 1:
I'm running postgresql 8.03 under Gentoo Linux and find that all actions
take at least a MINUTE (even dropdb and createdb). During this time, the
posgres account is locked up to the extent that one cannot even su to
it. (The su suceeds when the db operation completes.)
I assume something is mi
Poul Møller Hansen <[EMAIL PROTECTED]> writes:
> I have a problem with slow connects to a database server.
>
> In a little Java application I am starting 100 threads, each one making
> a database connection. The program is running on my laptop.
>
> When connecting to one server (AMD Opteron 2GHz w
I'm having troble creating a view here. Particularly, each time I try to
create a view, I get a FATAL error and the database server restarts.
Here are the logs:
LOG: sentencia: CREATE VIEW biblioteca.permisosoperadorprocesos AS
SELECT uag.admin, ugp.proceso
FROM unionadmingrupo
I have a problem with slow connects to a database server.
In a little Java application I am starting 100 threads, each one making
a database connection. The program is running on my laptop.
When connecting to one server (AMD Opteron 2GHz with Solaris &
pgsql version 8.0.3) the 100 connections ta
On Saturday 24 September 2005 00:09, Oleg Bartunov wrote:
> Ron,
>
> probably you need to write custom parser. tsearch2 supports
> different parsers.
>
To expand somewhat on what Oleg mentioned, you can find a howto on writing a
custom parser here :
http://www.sai.msu.su/~megera/postgres/gist/ts
25 matches
Mail list logo
