You and Stephan hit it right on the nose - our table has been
maliciously propagated with thousands of faulty values - once gone
index are in use and DB is SPEEDING along 8)
Thanks for your help!!!
-r
On Thu, 10 May 2001 21:49:28 + (UTC), in
comp.databases.postgresql.general you wrote:
>
"Richard Huxton" <[EMAIL PROTECTED]> writes:
> Why doesn't PG (or any other system afaik) just have a first guess, run the
> query and then if the costs are horribly wrong cache the right result.
?? Knowing that your previous guess was wrong doesn't tell you what the
right answer is, especially n
This is a followup to a problem report Stephen Livesey made back in
February, to the effect that successive insertions got slower and
slower. At the time we speculated that btree indexes had a problem
with becoming out-of-balance when fed steadily increasing data values.
I have now tried to repro
Chris Jones <[EMAIL PROTECTED]> writes:
>> Ah. You must have a few values that are far more frequent (like tens of
>> thousands of occurrences?) and these are throwing off the planner's
>> statistics.
> I had a similar situation, where I had a lot of rows with 0's in
> them. Changing those to N
Zak McGregor <[EMAIL PROTECTED]> writes:
> It pads the output of the month to 9 places, btw.
You can suppress the padding with the right format-string incantation.
See the docs.
regards, tom lane
---(end of broadcast)---
TI
On Thu, May 10, 2001 at 05:22:07PM -0400, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > No the query usually returns between 0 and 5 rows. Usually not zero -
> > most often 1.
>
> Ah. You must have a few values that are far more frequent (like tens of
> thousands of occurrences?) and these a
On Thu, 10 May 2001, David Wheeler wrote:
> Hi All,
>
> I need to create a custom constraint (or a trigger?) on a table, and could
> use some help.
To answer my own question, this is what I've come up with. To anyone who
happens to decide to entertain him/herself by looking this over: if you
h
> > Probably we could
> > optimize this somehow, but allocation of new page in bufmgr is
> > horrible and that's why we have locks in hio.c from the beginning.
>
> See later message about eliminating lseeks --- I think we should be
> able to avoid doing this lock for every single tuple, as it doe
Tom Lane wrote:
>
> "Mikheev, Vadim" <[EMAIL PROTECTED]> writes:
> > access/heap/hio.c:RelationGetBufferForRelation() uses LockPage
> > (ie lmgr -> semops) to syncronize table extending.
>
> But no semop should occur unless somebody is actually blocking on
> the lock. John's trace only showed o
[EMAIL PROTECTED] writes:
> No the query usually returns between 0 and 5 rows. Usually not zero -
> most often 1.
Ah. You must have a few values that are far more frequent (like tens of
thousands of occurrences?) and these are throwing off the planner's
statistics.
7.2 will probably do better
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> in src/include/postgres_ext.h, it mentions that "... databases with
> different NAMEDATALEN's cannot interoperate!", and i was wondering if
> included when altering NAMEDATALEN for a database that already has data
> even if performing a pg_dum
On Thu, 10 May 2001 15:30:01 -0400
Fran Fabrizio <[EMAIL PROTECTED]> wrote:
>
> I'm looking all over the place in the Pg docs and Momjian book and
> having no luck finding any functions that would turn a timestamp such as
> 2001-05-08 23:59:59-04 into May 8, 2001. (i.e. do what date_format()
>
"Mikheev, Vadim" <[EMAIL PROTECTED]> writes:
> access/heap/hio.c:RelationGetBufferForRelation() uses LockPage
> (ie lmgr -> semops) to syncronize table extending.
But no semop should occur unless somebody is actually blocking on
the lock. John's trace only showed one active backend, so I figured
is it safe to change NAMEDATALEN, dump an existing database, recompile,
and then restore the database?
in src/include/postgres_ext.h, it mentions that "... databases with
different NAMEDATALEN's cannot interoperate!", and i was wondering if
included when altering NAMEDATALEN for a database tha
No the query usually returns between 0 and 5 rows. Usually not zero -
most often 1.
-r
On Thu, 10 May 2001 19:47:32 + (UTC), [EMAIL PROTECTED] ("Mitch
Vincent") wrote:
>Does that query really return 9420 rows ? If so, a sequential scan is
>probably better/faster than an index scan..
>
>-Mi
On Thu, May 10, 2001 at 03:36:14PM -0400, Mitch Vincent wrote:
:
: 1,000 is one thousand, right?
:
: 1.000 is one, right?
Only in America. The numerical use of commas and decimal points is just
the opposite in other parts of the world like Europe, South America, and
the Middle East. P
I'm looking all over the place in the Pg docs and Momjian book and
having no luck finding any functions that would turn a timestamp such as
2001-05-08 23:59:59-04 into May 8, 2001. (i.e. do what date_format()
was doing for me in MySQL.) Is there equivalent functionality in Pg?
Thanks,
Fran
Ok, over my head -- someone has schooled me.. My apologies for the list
noise.
-Mitch
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
1,000 is one thousand, right?
1.000 is one, right?
Since the decimal isn't just an arbitrary separator when we're speaking
of decimal numbers (1.00 is certainly a lot different than 1000.00) I guess
I don't follow what the problem is.. How can you have one thousand
represented as 1.0
On Thu, May 10, 2001 at 01:22:56PM +, [EMAIL PROTECTED] wrote:
> I vacuum every half hour! Here is the output from EXPLAIN:
>
> NOTICE: QUERY PLAN:
>
> Seq Scan on pa_shopping_cart (cost=0.00..7237.94 rows=9420 width=296)
>
> EXPLAIN
>
> Thanks!
Then try
set enable_seqscan to off;
exp
Does that query really return 9420 rows ? If so, a sequential scan is
probably better/faster than an index scan..
-Mitch
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 9:22 AM
Subject: Re: Query not using index
> I vacuum every half
On Thu, 10 May 2001, Ben Carterette wrote:
> I'm running a web server on one machine (Apache 1.3+Tomcat 3.2+mod_jk)
> with some databases (postgresql 7.1), and a dedicated database server on
> another machine (postgresql 7.0.2). A lot of my web pages establish a
> connection to a database on eit
Hi all...i'm converting an access 97 database to pg and i have a little
problem...since i'ìm in italythousand use commas as a separator and not
dots (eg 1,000 not 1.000)... is there a function to instruct postgresql to
use the comma instead of the dot?? I would be very usefull because it would
desc is a reserved keyword (used in ORDER BY to indicate descending order)..
You can use keywords as field names though you have to put the in quotes (as
you found out!).
-Mitch
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 2:08 PM
S
On Thu, May 10, 2001 at 02:08:56PM -0400, [EMAIL PROTECTED] wrote:
> I have 7.1
>
> Can someone take a look the following
> and tell me why I'm getting errors?
> I'm completely baffled!
>
>
> what=> create table bla(desc text,def text,data text);
> ERROR: parser: pa
desc is a keyword - ORDER BY DESC-ending
Robert Creager
StorageTek
INFORMATION made POWERFUL
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> I have 7.1
>
> Can someone take a look the following
> and tell me why I'm getting errors?
> I'm completely baffle
I vacuum every half hour! Here is the output from EXPLAIN:
NOTICE: QUERY PLAN:
Seq Scan on pa_shopping_cart (cost=0.00..7237.94 rows=9420 width=296)
EXPLAIN
Thanks!
On Thu, 10 May 2001 18:19:16 + (UTC),
[EMAIL PROTECTED] (Stephan Szabo) wrote:
>
>Have you vacuum analyzed recently and
desc is a reserved word (descending, ascending, having, from, etc...),
as in:
select * from foo order by col_a desc;
That is why you need the double quotes.
jeff
Jeff Daugherty
Database Systems Engineer
Great Bridge LLC
[EMAIL PROTECTED] wrote:
> I have 7.1
>
> Can someone take a look the f
Thanks everyone for very quick reply.
The reason I found odd was I had
created another able with the same
field name and don't recall having
problems at the time with 7.0.3.
Or did I get the same problem
but I just forgot? I dumped
and reloaded 7.0.3 table to 7.1
without problem though.
On Thu,
is there any way to get access to the new and old records created by a
trigger in the function it calls?
i.e., if i have
create trigger after_insert after insert on foo
execute procedure trigger_after_insert_foo();
is there any way to do something like the following...
create function trigger
What would cause this trigger:
create trigger log_trigger
before insert on log
for each row
execute procedure update_host_table();
to only fire on the first insert per connection, but none of the subsequent inserts?
The trigger runs fine, the procedure it calls runs fine, but it only executes
On Thu, 10 May 2001, Jonathan Sand wrote:
> I want to use the COPY command to read a bunch of data files. These
> files don't contain an id, so I want to use the SERIAL data type to
> auto-number the generated rows. COPY complains.
Destination table:
CREATE TABLE destination (id SERIAL, truc
Sorry, I clean forgot to tell
I'm running PG v7.02.
>> Help me please to resolve my problem.
TL> Postgres version?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Visio 2000 can do this (maybe not all versions though)
It can import a database and draw the links (P.K's)
I found Visio was a bit cruddy. Its clunky and easy to muck things
up, links also seem to unlink themselves. If there's a better (open source)
tool I would also like to know about it!
Mar
Hi.
I have currently changed from MySQL to PostgreSQL, and there is one
thing I'm not really getting...
When I create a new databse (with creatbd), all users are able to create
tables in this database. They are, how ever, not able to execute
commands on one another's tables, unless there are privi
Hi,
do you know of a tool which could be used to easily generate
entity-relationship diagrams (with integrity constraints, etc), in LaTeX
for example ?
This is a bit unlinked with PostgreSQL but I hope you won't hit me :)
Thank you.
---(end of broadcast)---
Hi,
Another point regarding /contrib or other directory like /tools is to
centralize tools for Pg. Also I can't be sure to always have an URL.
This one is dependant on the company I'm working now.
Life is moving.
Regards
Bruce Momjian wrote:
> [ Charset US-ASCII unsupported, converting... ]
>
I'm running postgresql 7.0.3 on redhat 7.0.
I want to use the COPY command to read a bunch of data files. These
files don't contain an id, so I want to use the SERIAL data type to
auto-number the generated rows. COPY complains.
The other recommended method (besides using SERIAL) is to use OID's.
38 matches
Mail list logo
