Sebastian Böhm writes:
> one question:
>
> what actually is tup_returned and tup_fetched ?
RTFM -- admittedly it's not so easy to find these since you have to know they
come from the following functions:
pg_stat_get_tuples_returned(oid) bigint Number of rows read by sequential
scans when argum
Hi,
one question:
what actually is tup_returned and tup_fetched ?
read from disc before scans and before aggregate ?
thanks
sebastian
2008/12/14 Dmitry Koterov :
>
> On Sun, Dec 14, 2008 at 3:36 PM, David Rowley wrote:
>>
>> 2008/12/14 Dmitry Koterov :
>> > The question: if the table "tbl" scanned to fetch "id" and calculate
>> > md5(id), or the value of "id" is brought directly from "idx" index with
>> > no
>> > table data acce
On Sun, Dec 14, 2008 at 3:36 PM, David Rowley wrote:
> 2008/12/14 Dmitry Koterov :
> > The question: if the table "tbl" scanned to fetch "id" and calculate
> > md5(id), or the value of "id" is brought directly from "idx" index with
> no
> > table data access at all? The second behaviour is logica
On 13/12/2008 19:13, SunWuKung wrote:
> I am trying to return an application error message on certain db
> raised errors to the form the info came from.
> What is the usual way for an application to identify the source of an
I suppose it depends on your development language/environment I use
Karsten Hilbert writes:
> This is what my 8.3 manual says:
> conkey â int2[] â pg_attribute.attnum â If a table constraint, list of
> columns which the constraint constrains â
> From that I wouldn't have figured it'd apply to foreign keys
> as well. So I assume it is fair to say that "f
On Sun, Dec 14, 2008 at 02:37:51PM -0500, Tom Lane wrote:
> Subject: Re: [GENERAL] how to find foreign key details (column, that is)
>
> Karsten Hilbert writes:
> > I cannot, however, for the life of it find out how to learn
> > the *column* the foreign key is on.
>
> pg_constraint.conkey has t
Karsten Hilbert writes:
> I cannot, however, for the life of it find out how to learn
> the *column* the foreign key is on.
pg_constraint.conkey has the referencing columns' numbers.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
I've to import something whose schema looks like
create table user(
userid serial primary key,
);
create table adresses_source(
userid int references user(userid),
addressid int
);
where addressid are a sequence for each userid as:
1,1
1,2
1,3
2,1
2,2
3,1
4,1
4,2
4,3
to something that sh
Hello all,
suppose I know that there are several tables with foreign
keys pointing to
demographics.identity.pk
With the help of pg_constraint I can get a list of *tables*
which hold those foreign keys (schema = demographics, tbl = identity,
col = pk):
select
%(schema)s as refer
I'm on 8.1 and having a client hang on log rotates.
To make the problem easier to duplicate, log rotates were set to two
minutes:
redirect_stderr = on# Enable capturing of stderr
into log
log_directory = 'pg_log'# enabled for 2 minute
rotation test
log_
On Sun, 14 Dec 2008, Michael Hall wrote:
I'm wondering if anyone can recommend a good general book on relational
database design.
...
Mick,
I highly recommend all the books by Joe Celko. He's been writing on
database issues for at least 20 years and communicates very well. I know
that he h
Hi guys, i need urgent help with this error:
pg_restore: [archiver (db)] error returned by PQputCopyData: cannot allocate
memory for output buffer
im my restore .
any idea with solve this error?
Paulo Moraes
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.y
2008/12/14 Dmitry Koterov :
> Hello.
>
> Suppose I have the following index:
>
> CREATE INDEX idx ON tbl USING btree (abc, def, id)
>
> and perform the query with index scan:
>
> SELECT md5(id)
> FROM tbl
> WHERE abc=1 AND def=2
> LIMIT 200
>
> The question: if the table "tbl" scanned to fetch "id
Hello.
Suppose I have the following index:
CREATE INDEX idx ON tbl USING btree (abc, def, id)
and perform the query with index scan:
SELECT md5(id)
FROM tbl
WHERE abc=1 AND def=2
LIMIT 200
*The question:* if the table "tbl" scanned to fetch "id" and calculate
md5(id), or the value of "id" is
This is slightly off topic perhaps, but maybe not too much ...
I'm wondering if anyone can recommend a good general book on relational
database design. I am using PostgreSQL, so a PG-centric book would be best, but
I'm mainly interested in the art/science of good SQL database design regardless
16 matches
Mail list logo
