Hello,
may I ask you some questions.
What is the performance difference between U320 15kRPM and U320 10kRPM ?
Does your RAID crontoller has some memory (e.g. 128 MB or 256 MB )
and something like memory backup write cache (like HP DL 380 server) ?
Do you use Intel or Opteron cpus ?
regards,
-Fr
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> This server just consumes more and more memory until it goes swap crazy
> and the load averages start jumping through the roof.
*What* is consuming memory, exactly --- which processes?
regards, tom lane
-
We're seeing memory problems on one of our postgres databases. We're
using 7.4.6, and I suspect the kernel version is a key factor with this
problem.
One running under Redhat Linux 2.4.18-14smp #1 SMP and the other Debian
Linux 2.6.8.1-4-686-smp #1 SMP
The second Debian server is a replicate
Hi,
On Mon, 12 Dec 2005, Joshua D. Drake wrote:
I saw it listed on the main pg web page but no details are available.
When the docs get updated there is the release notes section.
Alternatively, you can see the development version of docs:
http://developer.postgresql.org/docs/postgres/rel
It sure is. Gentoo with kernel version 2.6.12, built for x86_64.
Looks like we have a contender for the common factor. :)
Please tell me you're *not* running a production database on Gentoo.
regards, tom lane
You don't even want to know how many companies I know that are doin
Mike Rylander <[EMAIL PROTECTED]> writes:
> On 12/12/05, Will Glynn <[EMAIL PROTECTED]> wrote:
>> Mike: is your system AMD64, by any chance? The above system is, as is
>> another similar story I heard.
> It sure is. Gentoo with kernel version 2.6.12, built for x86_64.
> Looks like we have a cont
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Mon, Dec 12, 2005 at 06:26:37PM -0500, Tom Lane wrote:
>> No. Avoiding that would require a new approach to
>> vacuum-vs-ordinary-indexscan interlocking, so it won't happen until
>> someone has a Bright Idea (tm).
> Plus there is a TODO to only vacu
On Mon, Dec 12, 2005 at 06:26:37PM -0500, Tom Lane wrote:
> Wes <[EMAIL PROTECTED]> writes:
> > The problem was determined to be due to the fact that indexes are vacuumed
> > in index order, not in disk storage order. I don't see anything about this
> > in the "What's new" for 8.1. Has anything b
On Mon, Dec 12, 2005 at 02:38:57PM +0200, Marko Kreen wrote:
>
> I needed to re-set all permissions on a database as the database
> access philosophy changed. But as it had a lot of tables, I was
> losing overview very quick. The original permission script used
> m4 for SQL generation, but it di
Benjamin Smith <[EMAIL PROTECTED]> writes:
> And, this dropped the query time from between 2.2-30 seconds all the
> way down to just 55-ish ms, without any new indexes! What's more, the
> improvement came from a move of a block I thought more or less
> unimportant!
> // tries to put jaw back into
Wow! I did exactly what you suggested, and played with the ordering for about
20-30 minutes. After 10 minutes or so, I'd gotten the response time down to
1700 ms from 2200 ms.
Moving the join conditions up into the "FROM" clause, and dropping the "WHERE"
clause altogether allowed me to reorder
hi,
It was a stupid error on my part.
I was declaring the function to return varchar when i was actually
returning integer. Also, i looked at varchar.c which was a great help.
It had a function that shows how to convert varchar to cstring.
Thanks tom,
vishOn 12/12/05, vishal saberwal <[EMAIL PRO
i am sorry for misleading subject line ...
thanks for your tip.
Perhaps fmgr has more in it that i need to understand and study so as to convert text/varchar to char* .
thanks,
vishOn 12/12/05, Tom Lane <[EMAIL PROTECTED]> wrote:
vishal saberwal <[EMAIL PROTECTED]> writes:> xy_db=# create or r
Benjamin Smith <[EMAIL PROTECTED]> writes:
> The example that I gave was a small one to illustrate my understanding of
> multiple foreign keys, indexes and how they work together. (or don't) The
> actual query is quite a bit bigger and nastier. I've considered breaking it
> up into smaller piece
The example that I gave was a small one to illustrate my understanding of
multiple foreign keys, indexes and how they work together. (or don't) The
actual query is quite a bit bigger and nastier. I've considered breaking it
up into smaller pieces, but this query has been extensively tested and
vishal saberwal <[EMAIL PROTECTED]> writes:
> xy_db=# create or replace function file_check(varchar) returns varchar as
> xy_db-# '/root/resource_test.so','file_check' language 'c';
> CREATE FUNCTION
> k2_db=# select file_check('/ResourceFS/IconFS/Alarm/My.gif');
> server closed the connection unex
hi all,
I have read through the fmgr's readme but havent been able to solve my problem with accessing the file.
I gave the permissions: [EMAIL PROTECTED] /]# chmod 777-r
/ResourceFS" and have made sure the file i am trying to access
does exist.
I am not sure where i am going wrong.
/*
gcc -Wall
Wes <[EMAIL PROTECTED]> writes:
> The problem was determined to be due to the fact that indexes are vacuumed
> in index order, not in disk storage order. I don't see anything about this
> in the "What's new" for 8.1. Has anything been done to resolve this?
No. Avoiding that would require a new
Martijn van Oosterhout writes:
> On Mon, Dec 12, 2005 at 08:43:52AM -0600, Tony Caduto wrote:
>> Is there any special C headers (for creating functions that return
>> results?) that are PG specific that would need to be ported to Pascal?
> Well, I don't know about any special C headers. The examp
On Mon, 2005-12-12 at 17:04 -0600, Tony Caduto wrote:
> Is there a change history available on the web without having to
> download the whole source distro?
>
> I saw it listed on the main pg web page but no details are available.
When the docs get updated there is the release notes section.
Jo
Is there a change history available on the web without having to
download the whole source distro?
I saw it listed on the main pg web page but no details are available.
Thanks,
Tony
---(end of broadcast)---
TIP 1: if posting/reading through Usen
Some time ago I reported a problem where right after an index rebuild vacuum
might take a couple of hours, but gets slower and slower at a seeming
increasing rate as time goes on. What takes a couple of ours after a full
index rebuild now takes 12 hours or more.
The problem was determined to be d
Rich Doughty <[EMAIL PROTECTED]> writes:
> I have a view vw_tokens defined as
> ...
> I cannot however perform a meaningful join against this view.
> ...
> PG forms the full output of the view.
You seem to be wishing that PG would push the INNER JOIN down inside the
nested LEFT JOINs. In general,
On Dec 10, 2005, at 6:37 PM, Benjamin Arai wrote:
For the most part the updates are simple one liners. I currently
commit in large batch to increase performance but it still takes a
while as stated above. From evaluating the computers performance
during an update, the system is thrashin
On Mon, 12 Dec 2005 21:34:42 +0100, Tino Wildenhain wrote:
> Am Montag, den 12.12.2005, 15:26 -0500 schrieb Matthew T. O'Connor:
>> Jerry LeVan wrote:
>> > Are there any (detailed) instructions available on how to connect
>> > OpenOffice 2 and Postgresql 8.1.
>> >
>> > I have the jdbc driver(s) fr
On Wed, Dec 07, 2005 at 12:11:22PM +0200, Sim Zacks wrote:
> select version()
> "PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC
> i686-pc-linux-gnu-gcc (GCC) 3.3.5 (Gentoo Linux 3.3.5-r1, ssp-3.3.2-3,
> pie-8.7.7.1)"
>
> I am using PG_Autovacuum with postgresql 8.01 and it doesn't seem
On Mon, Dec 05, 2005 at 08:24:16AM -0500, John D. Burger wrote:
> >>There are practical applications, eg, 1024-bit keys are fairly common
> >>objects in cryptography these days, and that equates to about 10^308.
> >>I don't really foresee anyone trying to run crypto algorithms with SQL
> >>NUMERIC
On 12/12/05, Will Glynn <[EMAIL PROTECTED]> wrote:
> Mike Rylander wrote:
>
> >Right, I can definitely see that happening. Some backends are upwards
> >of 200M, some are just a few since they haven't been touched yet.
> >
> >
> >>Now, multiply that effect by N backends doing this at once, and you'
On Mon, 2005-12-12 at 15:26 -0500, Matthew T. O'Connor wrote:
> Jerry LeVan wrote:
> > Are there any (detailed) instructions available on how
> > to connect OpenOffice 2 and Postgresql 8.1.
> >
> > I have the jdbc driver(s) from postgresql.org...
> >
> > I am running FC4 and have access to DB's on
Am Montag, den 12.12.2005, 15:26 -0500 schrieb Matthew T. O'Connor:
> Jerry LeVan wrote:
> > Are there any (detailed) instructions available on how
> > to connect OpenOffice 2 and Postgresql 8.1.
> >
> > I have the jdbc driver(s) from postgresql.org...
> >
> > I am running FC4 and have access to DB
Jerry LeVan wrote:
Are there any (detailed) instructions available on how
to connect OpenOffice 2 and Postgresql 8.1.
I have the jdbc driver(s) from postgresql.org...
I am running FC4 and have access to DB's on a Mac
and the Linux box.
This would be a helpful thing to have. I know there is
Mike Rylander wrote:
Right, I can definitely see that happening. Some backends are upwards
of 200M, some are just a few since they haven't been touched yet.
Now, multiply that effect by N backends doing this at once, and you'll
have a very skewed view of what's happening in your system.
A
Are there any (detailed) instructions available on how
to connect OpenOffice 2 and Postgresql 8.1.
I have the jdbc driver(s) from postgresql.org...
I am running FC4 and have access to DB's on a Mac
and the Linux box.
Thanks,
Jerry
---(end of broadcast)-
On Mon, Dec 12, 2005 at 10:08:12AM -0800, vishal saberwal wrote:
> hi all,
> I am having problems creating functions. Though i can still replace the
> already existing functions that i had created a while back in postgres
> 7.4.5.Now I am running postgres
> 8.0.1.
>
> The code below compiles witho
hi all,
guess i should have read the documentation more carefully.
Function was created when i did add "link_symbol" to the path.
If this is the real reason, then I believe this is something new as it used to work without using link_symbol before.
vishOn 12/12/05, vishal saberwal <[EMAIL PROTE
On Mon, Dec 12, 2005 at 08:43:52AM -0600, Tony Caduto wrote:
> I know Delphi/Kylix can create C style DLLs and SOs with the C style
> calling convention, so I "assume" Free Pascal does as well.
>
> Is there any special C headers (for creating functions that return
> results?) that are PG specifi
On Mon, Dec 12, 2005 at 13:04:05 -0500,
Jim Buttafuoco <[EMAIL PROTECTED]> wrote:
>
> try
>
>
> select '2005-12-01'::date + (456.5::float || ' seconds')::interval;
> ?column?
>
> 2005-12-01 00:07:36.50
> (1 row)
You are better off doing a multiply. So
On Dec 12 08:09, Volkan YAZICI wrote:
> On Dec 12 01:00, David Rysdam wrote:
> > I have a table that has a date field and a "real" field that represents
> > a number of seconds. I want select the date field + the seconds field.
> > Just adding it doesn't work. Casting to interval doesn't work.
On Dec 12 01:00, David Rysdam wrote:
> I have a table that has a date field and a "real" field that represents
> a number of seconds. I want select the date field + the seconds field.
> Just adding it doesn't work. Casting to interval doesn't work.
> to_date/to_timestamp don't work. How do I
hi all,
I am having problems creating functions. Though i can still replace the
already existing functions that i had created a while back in postgres
7.4.5 .Now I am running postgres 8.0.1.
The code below compiles without errrors.
gcc -Wall -I /root/postgresql-8.0.1/src/include -shared -Wl,-sona
I knew it had to be something like this, but the search space was just
too big. Thanks!
Jim Buttafuoco wrote:
try
select '2005-12-01'::date + (456.5::float || ' seconds')::interval;
?column?
2005-12-01 00:07:36.50
(1 row)
-- Original Messag
try
select '2005-12-01'::date + (456.5::float || ' seconds')::interval;
?column?
2005-12-01 00:07:36.50
(1 row)
-- Original Message ---
From: David Rysdam <[EMAIL PROTECTED]>
To: "pg >> Postgres General"
Sent: Mon, 12 Dec 2005 13:00:13
I have a table that has a date field and a "real" field that represents
a number of seconds. I want select the date field + the seconds field.
Just adding it doesn't work. Casting to interval doesn't work.
to_date/to_timestamp don't work. How do I do this?
---(end
John McCawley wrote:
You should be able to use my trick...the join that is giving you the
problem is:
SELECT *
FROM
tokens.ta_tokenhist h INNER JOIN
tokens.vw_tokenst ON h.token_id = t.token_id
WHERE
h.sarreport_id = 9 ;
ta_tokenhist is already part of your view, right?
You should be able to use my trick...the join that is giving you the
problem is:
SELECT *
FROM
tokens.ta_tokenhist h INNER JOIN
tokens.vw_tokenst ON h.token_id = t.token_id
WHERE
h.sarreport_id = 9 ;
ta_tokenhist is already part of your view, right? So you should be able
First of all, check out this thread:
http://archives.postgresql.org/pgsql-general/2005-11/msg00734.php
I had a similar performance issue with a view. Look at my solution and
it might help you out.
Second, you might want to change your token history status from a string
to an integer that re
John McCawley wrote:
First of all, check out this thread:
http://archives.postgresql.org/pgsql-general/2005-11/msg00734.php
I had a similar performance issue with a view. Look at my solution and
it might help you out.
i'm not sure that'll help in my case as ta_tokens has a 1-to-many
relatio
I have a view vw_tokens defined as
CREATE VIEW tokens.vw_tokens AS SELECT
-- too many columns to mention
FROM
tokens.ta_tokens t LEFT JOIN
tokens.ta_tokenhist i ON t.token_id = i.token_id AND
i.status = 'issued' LEFT JOIN
> After reading the explanation, this seems way too specialized a
> situation to make a good argument that we need a general feature
> of the sort.
Ok, however, thanks for your time on it, anyway!
> You can get to where you need to be by passing an indicator in
> the trigger arguments
Argh, it's
Frank van Vugt <[EMAIL PROTECTED]> writes:
>> It might also work for you to do this with access rights.
> Well, actually that's kinda how it's working at the moment, however I would
> rather avoid this additional dependancy on user/role since it's really
> field/situation-dependent (see below).
DANTE ALEXANDRA <[EMAIL PROTECTED]> writes:
> Then, on each table, I have launched the "VACUUM FULL ANALYZE" command
> as a non-root user.
> This command failed on the last table, the biggest, called "lineitem"
> which contains 1799989091 rows (near 300 Gb of datas).
VACUUM FULL requires workspa
On 11/12/05, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
> Is there a practical way to make a guess what language a document is
> written in and auto magically use the adequate TSearch config? I thought
> of looking up the document's words in various dicts and use the one with
> the most matches
That said, pascal has historically had a different calling convention
and that is likely to cause the most issues.
Free Pascal offers the cdecl modifier, which allows to declare and
access functions with C style call convention. However, someone needs to
write the necessary interface to th
Martijn van Oosterhout wrote:
> That said, pascal has historically had a different calling convention
and that is likely to cause the most issues.
Have a nice day,
I know Delphi/Kylix can create C style DLLs and SOs with the C style
calling convention, so I "assume" Free Pascal does as well
On 12/12/05, Marcus Engene <[EMAIL PROTECTED]> wrote:
> > That a simple case, what about languages as norwegian or german? They
> > has compound words and ispell dictionary can split them to lexemes.
> > But, usialy there is more than one variant of separation:
> >
> > forbruksvaremerkelov
>
> I want silent, non-interactive installation postgresSQL on Windows.
>
> I don't want to use the .msi provided for silent
> installation. Is there any method by which I can just copy
> the binaries and run some postgres script which will
> configure the Postgres to work same as installed one?
Hello!
Please, help. I need to get complete list of 'client_encoding'
values supported by the PostgreSQL Server. Can I somehow get these
values using select query or function call?
Best regards,
Kovalevski Andr
Richard,
Thanks for the response. I see your point. I've been using the table oid to
find a node in a linked list of structures that define several attributes of
a column in relation to the interface. Matching on the column name doesn't
work because some columns share the same name across table
I want silent, non-interactive installation postgresSQL on Windows.
I don’t want to use the .msi provided for silent
installation. Is there any method by which I can just copy the binaries and run
some postgres script which will configure the Postgres to work same as installed
one?
Thanks
> >> Ratio: when deferred triggers on table A are used to calculate field
> >> values of table B (which then obviously need an update), one might want
> >> to prevent direct updates on these fields of table B
[BW III]
> It might also work for you to do this with access rights.
Well, actually that
> That a simple case, what about languages as norwegian or german? They
> has compound words and ispell dictionary can split them to lexemes.
> But, usialy there is more than one variant of separation:
>
> forbruksvaremerkelov
> forbruk vare merke lov
> forbruk vare merkelov
> forbruk varemerke l
I needed to re-set all permissions on a database as the database
access philosophy changed. But as it had a lot of tables, I was
losing overview very quick. The original permission script used
m4 for SQL generation, but it didn't cut anymore.
So I wrote a small Python script which read a .ini-s
Terry Lee Tucker wrote:
There are several tables involved in the query. Note that "my_func(column_3)"
from above does some formatting of the data. I issue the command with
PQsendQuery(). When loading a widget with data, I have a need of knowing the
table oid from which the data came. I have b
Hello List:
I have a situation where I'm doing a select statement of the form:
SELECT column_1, column_2, my_func(column_3) AS "column_3",
column_4... FROM my_table INNER JOIN other_table ON ...
There are several tables involved in the query. Note that "my_func(column_3)"
from above does some fo
Francesco Lilley wrote:
Hello, i've just dowloaded and installed Postgres 8.1 and i've
installed the latest version of Odbc Drivers 8.01.0103 and created
the Odbc on Windows. But i have some connections problems...the first
time i wrote a C-like program in order to make some concurrent
simultaneu
Hello,
i've just dowloaded and installed Postgres 8.1 and
i've installed the latest version of Odbc Drivers 8.01.0103 and created the Odbc
on Windows.
But i have some connections problems...the first
time i wrote a C-like program in order to make some concurrent simultaneus
connections and t
am 12.12.2005, um 16:55:21 +0530 mailte Prakash Nair folgendes:
> Hello,
>
> I have postgreSQL 8.0.4 running on a RHES machine. I would
> like to connect to the database from my Windows verson of Crystal Reports.
>
>
> Does anyone knows, which driver i need to install in my
> Windows machi
Hello,
I have postgreSQL 8.0.4 running on a RHES machine. I would like to connect to the database from my Windows verson of Crystal Reports.
Does anyone knows, which driver i need to install in my Windows machine ?
Thanks,
Prakash.
--On Montag, Dezember 12, 2005 11:16:19 +0100 Martijn van Oosterhout
wrote:
On Sun, Dec 11, 2005 at 10:03:57PM -0600, Tony Caduto wrote:
Has there ever been any discussion on
using Free Pascal to create functions (C Style)?
I know pascal can be used to create user defined functions in other
I was playing around with negative offsets:
select * from table1 order by col1 offset -5 limit 25;
select * from table1 order by col1 offset -25 limit
25;
select * from table1 order by col1 offset -250 limit
25;
They all return the same resultset (offset 0). Is
there even any point in allowing ne
On Sun, Dec 11, 2005 at 10:03:57PM -0600, Tony Caduto wrote:
> Has there ever been any discussion on
> using Free Pascal to create functions (C Style)?
>
>
> I know pascal can be used to create user defined functions in other
> databases like Firebird (which was originally coded in C and now C++
Hi,
you need to increase maintenance_work_mem in postgresql.conf file.
http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
Regards
Pandu
On 12/12/05, DANTE ALEXANDRA <[EMAIL PROTECTED]> wrote:
> Hello,
>
> This is my first posting in this mailing list and I am a PostGreSQL newbie.
>
Hello,
This is my first posting in this mailing list and I am a PostGreSQL newbie.
I've posted this message in the "novice" mailing list last friday, but I
have any response.
I hope somenone could help me.
I realize a benchmarck on PostGreSQL on a 300Gb database. I used the
release 8.1.0.
I
Tom Lane wrote:
> You've got that 100% backwards: you should be complaining to Debian that
> it's not their business to editorialize on the default setting.
I've forwarded this thread to Debian as a bug report. Their answer is
they will discuss this setting again when 8.2 comes out. The full answe
74 matches
Mail list logo
