On Fri, Jul 04, 2003 at 02:22:39PM -0700, Maksim Likharev wrote:
> Ok, what I see here tells me that text is slower then fixed len varchar,
> due to stored in separate table ( but how else you can store long fields
> ).
No, sorry, I think I was unclear. varchar() is the same thing as
text(); they
I still having that same error on my simple query:
Tables has been rebuild, reindexed, and DB has been moved to another
computer,
worked for a while, and now aging same story.
We run PG 7.3
I repeat query:
SELECT p.docid FROM prod.t_documents AS p
INNER JOIN t_tempdocs AS t
ON p.docid
Do you realize your entire website is hosed? NONE of the download sites
will resolve, and NONE of the mirror sites work (or will resolve).
What is up?
Dan
---(end of broadcast)---
TIP 8: explain analyze is your friend
Pedro Alves wrote:
> Hi.
>
>
> I have a doubt:
>
> If I make:
>
> update stockline set status=3 where id IN (select id from lap_mpdetail_view where
> lap=3976)
>
> postgres makes an Seq Scan on stockline.
>
> when stockline is big, it is better to make an select id fro
If you make an opclass that orders in the reverse order you can use that
opclass in creating the index (which effectively can give you an index
like x, y desc by using the new opclass on y). There was some talk
recently about whether we should provide such opclasses as builtins or
contrib items.
On Mon, 7 Jul 2003, Dmitry Tkach wrote:
> I understand that with the generic approach to operators in postgres it
> is, probably, not very feasible to try and teach _bt_first () to handle
> this situation automatically (it would need to know how to get
> next/previous value for every indexable ty
I am not sure if this is really a bug, but it certainly looks like one
to me...
I have a table that looks something like this:
create table huge_table
(
int x,
int y
);
create index huge_table_idx on huge_table (x,y);
It contains about 80 million rows...
I am trying to get those rows that
Hi.
I have a doubt:
If I make:
update stockline set status=3 where id IN (select id from lap_mpdetail_view where
lap=3976)
postgres makes an Seq Scan on stockline.
when stockline is big, it is better to make an select id from
lap_mpdetail_view where lap=3976) and progr
Thanks Tom. That is good info.
(gnashing of teeth in background)
Clay
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 02, 2003 6:46 PM
> To: Clay Luther
> Cc: Doug McNaught; [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Using C++ With SPI?
>
>
>
On Sunday 06 July 2003 12:39 pm, CSN wrote:
> Is it possible to have the datetime printed along with
> messages in PG's logs?
See postgresql.conf and use syslog or set:
log_timestamp = true
Cheers,
Steve
---(end of broadcast)---
TIP 3: if posting/
I believe that its more efficient to group INSERT's together and COMMIT
them in groups.
However, I am automatically entering a lot of data and some of its is
not unique. How can I reap the benefits of using BEGIN and COMMIT
without the whole block of transactions failing if one is duplicated.
Than
Just because all reported commits go in doesn't mean there won't be any
data loss.
If you pull the power cord, the DB should be in a consistent state barring
hardware and other issues. However there can be data loss, because the
clients might have been inserting data which may not be able to be
NM, it appears to be fixed now.
cwl
> -Original Message-
> From: Clay Luther
> Sent: Monday, July 07, 2003 3:59 PM
> To: [EMAIL PROTECTED]
> Cc: '[EMAIL PROTECTED]'
> Subject: www.postgresql.org FUBAR
>
>
> The following is the HTML of the www.postgresql.org homepage:
>
> --snip--
>
The following is the HTML of the www.postgresql.org homepage:
--snip--
http://www.postgresql.org/";>
--snip--
Basically, an empty page that is constantly reloaded.
Pretty FUBAR.
cwl
---(end of broadcast)---
TIP 7: don't forget to increase your f
I define an SQL function:
CREATE FUNCTION foo(timestamptz) AS '
...' LANGUAGE 'SQL';
Does the plan for the body get built at creation or execution time? I could
have sworn it was execution time, but timings on one function suggest
creation?
For those new to functions, plpgsql always prepares i
On Monday 07 Jul 2003 4:11 pm, Mattias Kregert wrote:
> > > If I turn fsync on and then pull the power cord while a
> > > number of clients are doing lots of inserts/updates and stuff,
> > > will the fsync then guarantee that no data will be lost or
> > > corrupted?
> >
> > You are surely kidding,
Do I save memory using a cursor from a SPI-connected procedure ?
I'm working on a table containing geometric objects and I'd like
to keep a geometry in memory just for the time it is needed, and
one at time, otherwise my machine is in permanent swapping.
--strk;
---(end o
If disabling FSYNC means that some my transaction log records will
reside in
some OS memory cache instead of been written on a disk after transaction
is commited,
I do now want to disable that.
-Original Message-
From: Mattias Kregert [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 200
> > If I turn fsync on and then pull the power cord while a
> > number of clients are doing lots of inserts/updates and stuff,
> > will the fsync then guarantee that no data will be lost or
> > corrupted?
> You are surely kidding, aren't you ?
>
> Karsten
No. No kidding.
Just to clarify, what I m
Should already be fixed ... tested from my location ... runaway postmaster
process doign a SELECT on the gborg database ... been running since Friday
*roll eyes* killed it off and things drop'd back down to normal ...
On Mon, 7 Jul 2003, Aaron Dummer wrote:
> Hello list,
>
> I'm unable to load h
> If I turn fsync on and then pull the power cord while a
> number of clients are doing lots of inserts/updates and stuff,
> will the fsync then guarantee that no data will be lost or
> corrupted?
You are surely kidding, aren't you ?
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291
Hello list,
I'm unable to load http://gborg.postgresql.org/. The
address is pingable, but the website won't load. Anybody know what
happened?
I also can't reach the mailing list archives, but
they have been down for a while...
Server admins: please let me know if you are
interested
Tom Lane wrote:
> "Mattias Kregert" <[EMAIL PROTECTED]> writes:
> > [ misguided analysis ]
>
> > Journalling FS will fix the FS problems, so the files are ok.
> > PG journal will fix the PG problems so the tables will be ok.
>
> Only if the journal is all down to disk before the crash.
>
> The f
"Mattias Kregert" <[EMAIL PROTECTED]> writes:
> [ misguided analysis ]
> Journalling FS will fix the FS problems, so the files are ok.
> PG journal will fix the PG problems so the tables will be ok.
Only if the journal is all down to disk before the crash.
The fundamental problem with fsync off
On Sunday 06 July 2003 08:44, [EMAIL PROTECTED] wrote:
> >Migrating to PostGreSql, i need to know how capable pgsql Functions
> >are , Vis a Vis SQLServer. can pgsql functions replace all
> >functionality provided by Stored Procedures of MSSqlServer
Dear Adivi,
You may also have a loo
On Mon, Jul 07, 2003 at 01:30:09PM +0200, Mattias Kregert wrote:
> In the case of disk failure, the files will probably be damaged anyway and
> then i'll have to install new hardware or format+check badblocks and then
> restore from the backup. I can't see how fsync would help in the case of
> dis
In the case of disk failure, the files will probably be damaged anyway and then i'll
have to install new hardware or format+check badblocks and then restore from the
backup. I can't see how fsync would help in the case of disk crash. Without reliable
raid or something i think this would be a cat
On 7 Jul 2003 at 12:59, Mattias Kregert wrote:
> First of all, disable FSYNC... that will speed things up a lot!
That shouldn't have been done so casually. Though can cause performance boost
and it degrades reliability of data as it can cause data corruption in case of
power/disk failure.
Bye
28 matches
Mail list logo
