Sorry this question is off topic.
Does anyone know a good resource for tomcat tuning
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
> The index that is failing is CREATE INDEX i1 ON conceptproperty USING btree
> (codingschemename, property, propertyvalue).
>
I don't think you could create indexes on text fields... there are
other type of indexes for that... tsearch2 for example
--
Atentamente,
Jaime Casanova
(DBA: DataBase
> I'm trying to load some data into PostgreSQL 8.0.3, and I got the error
> message "index row size 2904 exceeds btree maximum, 2713". After a
> bunch of searching, I believe that I am getting this error because a
> value that I am indexing is longer than ~ 1/3 of the block size - or the
> BLCKSZ
Dan Armbrust <[EMAIL PROTECTED]> writes:
> The index that is failing is CREATE INDEX i1 ON conceptproperty USING
> btree (codingschemename, property, propertyvalue).
>
> Usually, the 'propertyValue' field is fairly short - 100 chars or
> less. And in those cases, I need to be able to do an indexe
Andrus wrote:
>
> How I can read and reply to all messages without receiving them all
> to my e-mail mailbox ?
From the Mailing Lists page of the PostgreSQL site
http://www.postgresql.org/community/lists/:
"The mailing lists are also available at the PostgreSQL news server.
However, in order t
Dan Armbrust wrote:
Hmm, well, I don't know if it is actually building an index properly on
this column, I just assumed that it was. It doesn't fail on every
insert, only on the one that has a really long text value. I know it
doesn't use the index when I do "ILIKE" queries, resulting in poor
On 7/18/05, Lincoln Yeoh wrote:
> However, maybe padding for alignment is a waste on the disk - disks being
> so much slower than CPUs (not sure about that once the data is in memory ).
> Maybe there should be an option to reorder columns so that less space is
> wasted.
Out of curiosity, do I und
Andrus wrote:
I was faced with a similar issue. One suggestion I got from the Internet
was to create a shadow column that contains the values used in the Index,
with a dummy entry (in my case, the string ) for those records in
which the primary column is NULL. It works well for my app.
Mic
I believe that one should leave such on-the-fly disk compression to the
O/S. Postgresql already does compression for TOAST.
However, maybe padding for alignment is a waste on the disk - disks being
so much slower than CPUs (not sure about that once the data is in memory ).
Maybe there should b
INFO: free space map: 195 relations, 96448 pages stored; 417104 total
pages needed
DETAIL: Allocated FSM size: 1000 relations + 9 pages = 588 kB
shared memory.
I'm confused, do I need to set my fsm settings to 96448 or 417104 based
on this output?
Are fsm settings updated during a vac
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On Mon, Jul 18, 2005 at 14:44:26 -0500,
Dan Armbrust <[EMAIL PROTECTED]> wrote:
> I'm trying to load some data into PostgreSQL 8.0.3, and I got the error
> message "index row size 2904 exceeds btree maximum, 2713". After a
> bunch of searching, I believe that I am getting this error because a
Shane <[EMAIL PROTECTED]> writes:
> I am attempting a query using lseg values to find the point
> of intersection. The following query taken from the PG
> manual isn't working over here.
> select
> point(lseg '((-1,0),(1,0))', lseg
> '((-2,-2),(2,2))')
> ERROR: function point(lseg, lseg) does no
On Mon, 2005-07-18 at 11:53, Andrus wrote:
> >> I ran DELETE command from my ODBC client application.
> >> I want to get the number of rows deleted by this DELETE command.
> >
> > I'm sure ODBC provides a way to do that, but you're asking the wrong
> > list about what it is ... try pgsql-odbc.
>
>
On 18/07/2005 17:47 Andrus wrote:
Unfortunately, no result is returned if DELETE command is executed.
There is no SQLRowCount function in FoxPro.
That's probably a feature of the language and will be so regardless of the
database used. I expect it wraps the ODBC APIs up in a more managable fo
Sounds good -- I will try that. Will this REINDEX lock any queries
that are currently running on the database? And is there anway to
find out what table this toast table is related to?
Thanks,
Akash
On 7/18/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Akash Garg <[EMAIL PROTECTED]> writes:
> > I g
>> pgsql.odbc newsgroup has only 5 messages in the whole this year. None of
>> them has got any replies.
> I think you're making the classic mistake of equating the usenet news
> versions of a list with the actual mailing list.
>
> Take a look here:
>
> http://archives.postgresql.org/pgsql-odbc/20
>> Unfortunately, no result is returned if DELETE command is executed.
>> There is no SQLRowCount function in FoxPro.
>
> That's probably a feature of the language and will be so regardless of the
> database used. I expect it wraps the ODBC APIs up in a more managable
> form.
Paul,
If Microsoft S
I'm trying to load some data into PostgreSQL 8.0.3, and I got the error
message "index row size 2904 exceeds btree maximum, 2713". After a
bunch of searching, I believe that I am getting this error because a
value that I am indexing is longer than ~ 1/3 of the block size - or the
BLCKSZ variab
> Although others have suggested that you're going to need an additional
> table, I've not seen anyone explicitly state why this is causing you
> problems.
>
> Clearly, NULL should not be used to mean "Any". However, the only reason
> you're doing this is because you want a FK to the "department" t
Shane wrote:
Hi,
I am attempting a query using lseg values to find the point
of intersection. The following query taken from the PG
manual isn't working over here.
select
point(lseg '((-1,0),(1,0))', lseg
'((-2,-2),(2,2))')
ERROR: function point(lseg, lseg) does not exist
HINT: No functio
Juan Miguel Paredes <[EMAIL PROTECTED]> writes:
> DECLARE
> res helpdesk.tp_res_conestadosdisponiblessoporte;
> BEGIN
> IF estadoactual = 'Abierto' THEN
> SELECT INTO res.filas *
> FROM tbl_estadosoporte
Without having looked at the code, I suspect that plpgsql just assumes
res.filas
Dan Armbrust <[EMAIL PROTECTED]> writes:
> All of my other limitations on changing things aside - given a query
> like this:
>
> Select * from conceptproperty where codingSchemeName='foo' AND
> property='anotherfoo' and propertyValue ILIKE 'valu%'
>
> What indexe(s) would be recommended?
I'd index
Hi, folks!
Reading previous posts on returning composite types in pl/pgsql, I
still haven't found a good answer for this issue:
Let's say we create this table:
/*/
CREATE TABLE "tbl_estadosoporte" (
"id" CHAR(1
Hmm, well, I don't know if it is actually building an index properly on
this column, I just assumed that it was. It doesn't fail on every
insert, only on the one that has a really long text value. I know it
doesn't use the index when I do "ILIKE" queries, resulting in poor
performance... but
On Mon, 2005-07-18 at 16:01, Dan Armbrust wrote:
> Hmm, well, I don't know if it is actually building an index properly
> on this column, I just assumed that it was. It doesn't fail on every
> insert, only on the one that has a really long text value. I know it
> doesn't use the index when I do "
On Mon, 2005-07-18 at 15:17, Dan Armbrust wrote:
> We have built a Model for terminologies that we call The Lexical Grid
> (more info http://informatics.mayo.edu/LexGrid/index.php)
>
> LexGrid has multiple backend data storage mechanisms, including LDAP
> and SQL. We do our best to remain impleme
We have built a Model for terminologies that we call The Lexical Grid
(more info http://informatics.mayo.edu/LexGrid/index.php)
LexGrid has multiple backend data storage mechanisms, including LDAP
and SQL. We do our best to remain implementation independent - our SQL
implementations, for exam
I believe the correct way is the following.
1. get the oid from pg_class for relname='pg_toast_100194'
2. lookup up the relname from pg_class where reltoastrelid = the oid from the
first query.
so on my system
select oid from pg_class where relname='pg_toast_17070';
oid
---
17072
(1 r
Hello,
May I know the commands to retrieve objects' privileges info please?
Something like:
Object Type, Object name,creator,grantee,privilege,
is_creatable
===
table T1user1 user2 select
Akash Garg <[EMAIL PROTECTED]> writes:
> Sounds good -- I will try that. Will this REINDEX lock any queries
> that are currently running on the database? And is there anway to
> find out what table this toast table is related to?
IIRC, 100194 is the OID of the owning table.
Nevermind this question...
>
Where is the documentation on tsearch2?
Google first, ask second, I remind myself again... I knew I hadn't
seen it mentioned in the official postgresql manual.. didn't think
about it being an extension.
Dan
Dan Armbrust wrote:
Hmm, well, I don't know if it
> Or better:
> CREATE UNIQUE INDEX permission_unique_key
> (user_id,permission_id,department_id);
> CREATE UNIQUE INDEX permission_uninull_key (user_id,permission_id)
> WHERE department_id IS NULL;
>
> ...you may want to add WHERE department_id IS NOT NULL to the first query
> (or not). Anyway --
My ODBC client is Microsoft Visual FoxPro
I ran delete command using its sqlexec() function like:
SQLEXEC(nConnhandle, "DELETE FROM mytable")
sqlexec() function returns the result from ordinary select table in a
cursor SQLRESULT
Unfortunately, no result is returned if DELETE command is execu
Akash Garg <[EMAIL PROTECTED]> writes:
> I get this error when I run a VACUUM:
> INFO: vacuuming "pg_toast.pg_toast_100194"
> vacuumdb: vacuuming of database "friend" failed: ERROR: could not
> open segment 1 of relation "pg_toast_100194_index" (target block
> 1226167840): No such file or directo
>> I ran DELETE command from my ODBC client application.
>> I want to get the number of rows deleted by this DELETE command.
>
> I'm sure ODBC provides a way to do that, but you're asking the wrong
> list about what it is ... try pgsql-odbc.
Tom,
pgsql.odbc newsgroup has only 5 messages in the wh
In the Postgre documentation I could find ODBC references only to Postgre
7.2 and older.
Can anyone point me to ODBC documentation for version 8?
Bob Pawley
I get this error when I run a VACUUM:
INFO: vacuuming "pg_toast.pg_toast_100194"
vacuumdb: vacuuming of database "friend" failed: ERROR: could not
open segment 1 of relation "pg_toast_100194_index" (target block
1226167840): No such file or directory
I'm assuming I can just delete and recreate
I looked in the data directory of postgres -- where else should I look for it?
Akash
On 7/6/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Wed, Jul 06, 2005 at 06:55:09PM -0700, Akash Garg wrote:
> > This is Suse Enterprise 9.0 running on a quad Opteron Newisys machine.
> > It has 32 gb of RAM
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Mon, 18 Jul 2005, Tom Lane wrote:
>> I don't see why.
> Except that before I think the order would have looked like (for 1 row)
> Originating Action
> Trigger A on originating table that does update
> Trigger B on originating table that does update
>
On Mon, 18 Jul 2005, Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Mon, 18 Jul 2005, Tom Lane wrote:
> >> AFAICS, if it worked for you in 7.4 it was only by pure chance. There
> >> was not then, and is not now, any logic that would prevent the FK checks
> >> from being applie
Am Montag, 18. Juli 2005 16:56 schrieb Tom Lane:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > But why doesn't it work if i make alle FK deferrable initially deferred?
>
> You didn't do it right --- I don't believe the code actually looks at
> pg_constraint, it looks at pg_trigger. And if you ar
Thanks...I just wanted to verify that it was the intended behaviour
prior to going in and changing code :)
- Joe Maldonado
Tom Lane wrote:
Joe Maldonado <[EMAIL PROTECTED]> writes:
It seems that TRUNCATE is first posting a lock on the table and then
waiting for other transactions to finis
On 7/18/05, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On 7/18/05, Andrus <[EMAIL PROTECTED]> wrote:
> > I have meaningful primary key in department table (department code used
> > inside enterptise), not a surrogate number (I use meaningful primary keys
> > whenever possible).
>
> OK, so then ju
Janning Vygen <[EMAIL PROTECTED]> writes:
> But why doesn't it work if i make alle FK deferrable initially deferred?
You didn't do it right --- I don't believe the code actually looks at
pg_constraint, it looks at pg_trigger. And if you are going to hack
pg_trigger directly, be careful to only ch
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Mon, 18 Jul 2005, Tom Lane wrote:
>> AFAICS, if it worked for you in 7.4 it was only by pure chance. There
>> was not then, and is not now, any logic that would prevent the FK checks
>> from being applied in an order you don't want.
> True, although
Am Montag, 18. Juli 2005 16:28 schrieb Stephan Szabo:
> On Mon, 18 Jul 2005, Tom Lane wrote:
> > Janning Vygen <[EMAIL PROTECTED]> writes:
> > > I have lots of tables with mutli-column PK and multi-column FK. All FK
> > > are cascading, so updating a PK should trigger through the whole
> > > databa
After an application updates, deletes, or inserts rows, it can call
SQLRowCount to determine how many rows were affected. SQLRowCount returns
this value whether or not the rows were updated, deleted, or inserted by
executing an UPDATE, DELETE, or INSERT statement, by executing a positioned
upda
On 7/18/05, Andrus <[EMAIL PROTECTED]> wrote:
> >> If I add ALL to department table, I must restrict all other tables of
> >> having
> >> ALL department. This is a big work and cannot be done nicely in Postgres.
> >
> > Not true. :) You simply need to add CHECK (departament_id <> 0) (assuming
> >
On Mon, 18 Jul 2005, Tom Lane wrote:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > I have lots of tables with mutli-column PK and multi-column FK. All FK are
> > cascading, so updating a PK should trigger through the whole database.
>
> > This worked earlier in 7.4:
>
> > UPDATE tipprunden SET t
Joe Maldonado <[EMAIL PROTECTED]> writes:
> It seems that TRUNCATE is first posting a lock on the table and then
> waiting for other transactions to finish before truncating the table
> thus blocking all other operations.
That's what it's supposed to do. If you have a problem with the length
of
* Joe Maldonado ([EMAIL PROTECTED]) wrote:
> It seems that TRUNCATE is first posting a lock on the table and then
> waiting for other transactions to finish before truncating the table
> thus blocking all other operations.
>
> Is this what is actually going on or am I missing something else? and
On Jul 18, 2005, at 7:00 AM, Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read the DELETE command docs but havent found any function.
Any idea ?
I don't use ODBC, but you should get that directly back
"Andrus" <[EMAIL PROTECTED]> writes:
> I ran DELETE command from my ODBC client application.
> I want to get the number of rows deleted by this DELETE command.
I'm sure ODBC provides a way to do that, but you're asking the wrong
list about what it is ... try pgsql-odbc.
re
Janning Vygen <[EMAIL PROTECTED]> writes:
> I have lots of tables with mutli-column PK and multi-column FK. All FK are
> cascading, so updating a PK should trigger through the whole database.
> This worked earlier in 7.4:
> UPDATE tipprunden SET tr_kurzname = 'schwarze2' where tr_kurzname =
> '
On Fri, 2005-07-15 at 13:46 +0300, Andrus wrote:
> I have table
>
> CREATE TABLE test( col1 CHAR NOT NULL, col2 CHAR,
> UNIQUE (col1, col2) );
>
> This table allows to insert duplicate rows if col2 is NULL:
>
> INSERT INTO test VALUES ( '1', NULL );
> INSERT INTO test VALUES ( '1', NULL );
>
Hello all,
We am running PostgreSQL 7.4.5 and recently we have noticed some strange
behaviour with regards to the TRUNCATE statement.
I think it would help to provide a quick overview of what we are doing
with the table in question in order to properly explain this.
The application which ar
Andrus, Is correct. There is no DNS involved because I am using 127.0.0.1 in
my config
and when connecting. But there is still a ~60second delay connecting and
more delays
to return the select * query.
I have other servers using 127.0.0.1 like Apache,MySql and none have this
delay connecting an
>> If I add ALL to department table, I must restrict all other tables of
>> having
>> ALL department. This is a big work and cannot be done nicely in Postgres.
>
> Not true. :) You simply need to add CHECK (departament_id <> 0) (assuming
> 0 is the ID of ALL departaments. You can even CREATE DOM
On 7/18/05, Andrus <[EMAIL PROTECTED]> wrote:
> > That's a lot of overhead for doing something very simple, like defining a
> > department key that means ALL and a row in the foreign table for it to
> > point to. Maintaining indices is a nontrivial performance trade-off.
>
> Yes, adding departmen
Ropel, thank you.
I'm looking for a better solution because
1. Some deletes take big amount of time. This increases run time a LOT
2. This requires the use of transaction if somebody changes data between
SELECT COUNT(*) and DELETE commands.
When transaction isolation level I must set for this ?
>>>"if department _id is NULL, user has access to all departments data."
>>>This is your problem. You've assigned meaning to the "value" NULL.
>>>
>>>CREATE TABLE permission (
>>> id serial,
>>> user_id CHAR(10) NOT NULL REFERENCES user,
>>> permission_id CHAR(10) NOT NULL REFERENCES privilege,
>>
> I was faced with a similar issue. One suggestion I got from the Internet
> was to create a shadow column that contains the values used in the Index,
> with a dummy entry (in my case, the string ) for those records in
> which the primary column is NULL. It works well for my app.
Michael,
t
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
>
> [EMAIL PROTECTED] wrote on 07/15/2005 02:49:09 PM:
>
>> On Fri, Jul 15, 2005 at 20:08:32 +0300,
>> Andrus <[EMAIL PROTECTED]> wrote:
>> >
>> > So I'll think still continuing to use null as unrestricted department
>> > access.
>>
Use 127.0.0.1 instead of localhost
In this case DNS is not used.
Andrus.
""Scott cox"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I am running PostgreSQL 8.0 on WinXP
> When I try to connect
>
> psql.exe" -h localhost -p 5432 template1 "postgres"
>
> I have to wait
> 30 sec
This week is looking busy for me but hopefully I'll be able to play around
with various vacuuming frequencies for this table ...
Thanks for all of your help; I'll report on my progress
-Dave
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 13, 2005
At least, you can do a "select count(*) from ..." just before the
delete, better if inside a transaction, if the query itself is not too
much expensive
Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read
Hi,
in the release docs it says:
"Non-deferred AFTER triggers are now fired immediately after completion of
the triggering query, rather than upon finishing the current interactive
command. This makes a difference when the triggering query occurred within a
function: the trigger is invoked
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read the DELETE command docs but havent found any function.
Any idea ?
Andrus.
---(end of broadcast)---
TIP 3: Have you che
On 7/18/05, Hannes Dorbath <[EMAIL PROTECTED]> wrote:
> Is there such a thing? PHP would be preferable, I don't want to maintain
> a MySQL-Server for such a small thing..
>
> Thanks in advance
I have used phpwiki (http://phpwiki.sourceforge.net/) with it. It's not
really a full blown wiki system
Is there such a thing? PHP would be preferable, I don't want to maintain
a MySQL-Server for such a small thing..
Thanks in advance
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
71 matches
Mail list logo