Christopher Kings-Lynne wrote:
I'm interested if anyone is using tablespaces? Do we have any actual
reports of people actually using them, to advantage, in the field??
Maybe the next postgresql.org survey could be on tablespace usage?
Chris
I have seen that tablespaces are widely used
Tom, Thanks a ton again, and, here's another problem that has me really puzzled-I'm starting with a fresh install of pgsql-8.0.1, and make 3 changes-1.) src/include/nodes/relation.h, Add a new Variable, hutz_idx_benefit to IndexOptInfo
typedef struct IndexOptInfo{../* Per IndexScan
On Fri, 2005-06-03 at 08:41 +0200, Hans-Jrgen Schnig wrote:
Christopher Kings-Lynne wrote:
I'm interested if anyone is using tablespaces? Do we have any actual
reports of people actually using them, to advantage, in the field??
Maybe the next postgresql.org survey could be on
On Fri, 2005-06-03 at 11:17 +0800, Christopher Kings-Lynne wrote:
Maybe the next postgresql.org survey could be on tablespace usage?
Could we plan a more comprehensive survey, with more than one question?
Judging by the number of people who fill out surveys, we would still get
thousands of
Dear all,
I completed my Computer Science MSc thesis in Athens University of Economics
and Business, A.U.E.B (under the supervision of Ass.Prof. V.Vassalos). Its
subject was DAIMON: Data Integration for a Mobile Network, i.e. mobile
peers integrating data from other peers. We used PostgreSQL
wht i wanted to do is... identify the tables which are getting used simultaneously... so that i can move them to different tablespaces
for that i tried to do sampling of "pg_statio_user_tables" for top 20 tables...(in terms of usage)... so that i know how much io is being done... for
On Thursday 02 June 2005 18:52, Vikram Kalsi wrote:
I am a MSEE student at Penn State (University Park), for the past few
months I have been working on modifying parts of PostgreSQL for my
research work. I doubt if my current work would serve any purpose for
pgsql since it is experimental and
i just noted one more thing...
pg_stat_get_db_blocks_fetched/hit is getting updated
but pg_stat_get_blocks_fetched/hit are not getting
updated.
why is this happening..
Regards
Himanshu
--- Himanshu Baweja [EMAIL PROTECTED] wrote:
wht i wanted to do is... identify the tables which
are
hi,
i want to know how CREATE table (creating a
relation)
works in Postgres.where can i find this in source
code.
also i want to know how postgres parser the
input(create table) and how is this connected to the
create table source code files.
Vikram Kalsi [EMAIL PROTECTED] writes:
...
tpcd=# select s_suppkey from supplier where (s_suppkey125 and
s_suppkey128) or (s_suppkey175 and s_suppkey185) or (s_suppkey200 and
s_suppkey215);
...
Actually, it seems all
the pointers in the List indexinfo or infos are pointing to the same
Himanshu Baweja [EMAIL PROTECTED] writes:
i just noted one more thing...
pg_stat_get_db_blocks_fetched/hit is getting updated
but pg_stat_get_blocks_fetched/hit are not getting
updated.
That's pretty difficult to credit after looking at the pgstat.c code:
every incoming blocks_fetched
--- Tom Lane [EMAIL PROTECTED] wrote:
That's pretty difficult to credit after looking at
the pgstat.c code:
every incoming blocks_fetched count is added to both
per-table and
per-database stats. I wonder if you are looking at
the wrong per-table
entries?
i am 100% sure
SELECT
Himanshu Baweja [EMAIL PROTECTED] writes:
SELECT pg_stat_get_db_blocks_fetched(764755937),
pg_stat_get_db_blocks_hit(764755937);
gives be constantly increasing stats and
SELECT relname,heap_blks_read from
pg_statio_user_tables order by heap_blks_read DESC
LIMIT 15;
is still showing me all
Dear All,
PGDN has a new treeview face. I would like
to know your opinion on the current state of the website.
If there are people who have ideas about
different topics please dont hesitate to let me know.
The current development site is:
http://www.truesoftware.net:8081/pgdn
Alon Goldshuv wrote:
I've been following this thread, and I'm a little confused. Could you
possibly clarify what you mean, by providing a couple of lines of input
as it would be formatted with escape processing turned off - containing
a text field with an embedded newline and tab and a null
On Fri, Jun 03, 2005 at 05:57:32PM +0200, Gevik Babakhani wrote:
Dear All,
PGDN has a new treeview face. I would like to know your opinion on
the current state of the website.
It's empty. Could you tell us a little bit about what you want to put
there?
Cheers,
D
--
David Fetter [EMAIL
Bruce,
Point taken.
Now, you can argue that
a different escape should be possible, or that some other escape syntax
could be used, but the existing mechanism is clearly 100% reliable when
used properly and not broken.
I think that having an option for another escape syntax (such as using
--- Tom Lane [EMAIL PROTECTED] wrote:
Himanshu Baweja [EMAIL PROTECTED] writes:
SELECT pg_stat_get_db_blocks_fetched(764755937),
pg_stat_get_db_blocks_hit(764755937);
gives be constantly increasing stats and
SELECT relname,heap_blks_read from
pg_statio_user_tables order by
The idea behind the PGDN is to provide a knowledgebase for pg developers.
I was thinking about gathering howto's, articles, questions and answers and
Of cource for those soles who are just starting programming pg to provide a
getting started portal...
-Original Message-
From: [EMAIL
Alon Goldshuv wrote:
Bruce,
Point taken.
Now, you can argue that
a different escape should be possible, or that some other escape syntax
could be used, but the existing mechanism is clearly 100% reliable when
used properly and not broken.
I think that having an option for another
Dear people,
Does anyone know how to execute an OS command from pgsql. I
would like to create a trigger that op on firing would run/execute an external
program.
Does such functionality exist or do I have to write my own trigger
function in C.
Reagrds,
Gevik.
Bruce,
Is there a good source of multi-byte copy data test cases? What is
currently done to test the trans-coding support? (where client and server
encodings are different)
I notice that the regression data in the CVS version of postgres does not
seem to include cases other than the ASCII data,
Gevik babakhani [EMAIL PROTECTED] writes:
Does anyone know how to execute an OS command from pgsql. I would like to
create a trigger that op on firing would run/execute an external program.
Use any of the untrusted PLs to execute system() or the like.
Whether this is a good idea or not is a
On Fri, Jun 03, 2005 at 20:56:44 +0200,
Gevik babakhani [EMAIL PROTECTED] wrote:
Dear people,
Does anyone know how to execute an OS command from pgsql. I would like to
create a trigger that op on firing would run/execute an external program.
Does such functionality exist or do I
It's great that you want to help in this area, but wouldn't be a better
idea to revamp techdocs.postgresql.org?
Gevik babakhani wrote:
The idea behind the PGDN is to provide a knowledgebase for pg developers.
I was thinking about gathering howto's, articles, questions and answers and
Of
Luke Lonergan wrote:
Bruce,
Is there a good source of multi-byte copy data test cases? What is
currently done to test the trans-coding support? (where client and server
encodings are different)
I notice that the regression data in the CVS version of postgres does not
seem to include
Bruce,
We have two and three-byte encodings, so 16-bit seems like it wouldn't
work. I am not aware of any specs except the C code itself.
Ok - no problem.
How about test data and cases? I see the SQL encoding examples used in
src/test/regress/sql for testing encoding in SQL, but are there
Luke Lonergan wrote:
Bruce,
We have two and three-byte encodings, so 16-bit seems like it wouldn't
work. I am not aware of any specs except the C code itself.
Ok - no problem.
How about test data and cases? I see the SQL encoding examples used in
src/test/regress/sql for testing
Bruce,
I have no idea what you are talking about. Again, give me facts about
what we currently don't do and what you want to do.
Currently:
- No statement of multi-byte control character format
- No tests to define or prove works flawlessly or identify when something
breaks the current
Look at peter eisentraut's procedural language PL/sh
It's on pgfoundry.
... John
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Saturday, June 04, 2005 5:16 AM
To: Gevik babakhani
Cc: pgsql-hackers@postgresql.org
Subject: Re:
Does anyone understand why the precedence of % is strange:
test= select -25 % -10;
?column?
--
-35
(1 row)
test= select -25 % (-10);
?column?
--
-5
(1 row)
Is it
vamsi krishna wrote:
hi,
i want to know how CREATE table (creating a
relation)
See DefineRelation() in backend/commands/tablecmds.c, and the routines
it calls.
also i want to know how postgres parser the
input(create table) and how is this connected to the
create table source code
Bruce Momjian pgman@candle.pha.pa.us writes:
Does anyone understand why the precedence of % is strange:
test= select -25 % -10;
It's treating it as ((-25) %) - (10), which is probably not so
surprising given the relative precedence of % and - ... though
I have to admit I'm not totally
33 matches
Mail list logo