possible. This seems like an issue that
would affect all inverse indices or more generally any index where
multiple clauses against the same index might have different
performance characteristics that could be determined at plan time (so
only for constant restrictions).
--Kurt Kartaltepe
ic or not. I actually tried to do
it in smaller batches before and I ended up calculating that it
would take 2 weeks to do the update.
Kurt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
was entirely due
> to sequential reads or may have been swapping. procinfo, vmstat,
> or just top can tell you about that.
There was no swapping.
The point is that it wasn't doing sequential reads but was
randomly accessing indexes for what looks like no good reason to
me.
Kurt
--
On Fri, May 06, 2016 at 11:38:27AM +0200, Kurt Roeckx wrote:
> On Thu, May 05, 2016 at 09:32:28PM -0700, Jeff Janes wrote:
> > On Wed, May 4, 2016 at 3:22 PM, Kurt Roeckx wrote:
> > > Hi,
> > >
> > > I have an update query that's been running for 48 hours
On Thu, May 05, 2016 at 09:32:28PM -0700, Jeff Janes wrote:
> On Wed, May 4, 2016 at 3:22 PM, Kurt Roeckx wrote:
> > Hi,
> >
> > I have an update query that's been running for 48 hours now.
> > Since it started it used about 2.5% CPU, and is writing to the
> >
keys should get updated.
Reading or writing the whole table shouldn't take that long, and I
have no idea why it's this slow. Does anybody have an idea why
it's this slow?
>From what I understand, the hash join should be the one I want to
use, I tried to force the others but th
710 a
> shot since it's basically a 320 with some reliability upgrades, and see how it
> goes.
>
> I will post my results here later, time permitting.
Oddly enough, Tom's Hardware has a review of the Intel offering today
- might be worth your while to take a look at it.
Kur
On Sun, Jul 24, 2011 at 14:48, Lonni J Friedman wrote:
> On Sun, Jul 24, 2011 at 2:46 PM, Kurt Buff wrote:
>> On Sun, Jul 24, 2011 at 14:36, Mario Puntin wrote:
>>>
>>> Hi everybody:
>>> I searched the web trying to find an answer to this, but found none.
o have, via a dropdown list and a set of fields for which you
sanitize the input.
Alternatively, build a GUI app that does the same thing, but if your
users are sophisticated and/or malicious you'll also have to build the
GUI with some sort of application authentication and encryption.
?::date and ?::date ..." syntax or send
statement causing problems?
Kind regards,
Radosław Smogura
On Tue, 04 Jan 2011 07:27:42 -0700, "Kurt Westerfeld"
wrote:
> "By the very definition of a prepared statement the query plan gets
> stored before the parameter values are
1 2:21 AM >>>
On 3 Jan 2011, at 23:48, Kurt Westerfeld wrote:
> I have a JDBC-based application which passes date/time parameters using JDBC
> query parameters, which is performing very badly (ie. doing full table
> scans). In an effort to try to narrow down the problem, I am t
I have a JDBC-based application which passes date/time parameters using JDBC
query parameters, which is performing very badly (ie. doing full table scans).
In an effort to try to narrow down the problem, I am taking the query and
running it in interactive SQL mode, but changing the date paramet
Kurt writes:
>> i'm trying to replicate tables containing XML-fields using Pg 8.4.4 and
>> 9.0B4 with Bucardo and got:
>> DBD::Pg::st execute failed: ERROR: could not identify an equality
>> operator for type xml
Tom Lane writes:
> You would need to create a d
Dear list,
i'm trying to replicate tables containing XML-fields using Pg 8.4.4 and
9.0B4 with Bucardo and got:
DBD::Pg::st execute failed: ERROR: could not identify an equality
operator for type xml
So i provided a primitive equality operator for the XML type in schema
pg_catalog:
CREATE
Dear list,
I'd like to ask, whether there is a way to exclude a table from the
regular transaction rollback.
Background:
I want to log all exceptions caused by my plpgsql-functions in a certain
log-table. To do this, instead of raising an exception directly, i call
a function that writes a record
dear list,
i'm trying to implement a general logging scheme with a plpgsql-trigger.
The idea is, that after an update the trigger compares the elements of
OLD and NEW and logs the changes made to the record columns. the trigger
should be usable by any table, so the field names are not known
before
;1'
ERROR: Failed to open database
Arrgh.
On Feb 7, 2008 9:19 AM, Kurt Schroeder <[EMAIL PROTECTED]> wrote:
> No, it didn't work! When I ran:
>
> [EMAIL PROTECTED]:/fossology/fossology-0.6.0$ psql -d fossology -U fossy -h
> localhost
>
> I got the error:
>
>
No, it didn't work! When I ran:
[EMAIL PROTECTED]:/fossology/fossology-0.6.0$ psql -d fossology -U fossy -h
localhost
I got the error:
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "fossy",
database "fossology", SSL off
I will work on resolving
with semicolon to execute query
\q to quit
fossology=> \q
On Feb 6, 2008 2:18 PM, brian <[EMAIL PROTECTED]> wrote:
>
>
> Can you connect to the database with psql?
>
--
Kurt Schroeder
[EMAIL PROTECTED]
http://kurtandsandy.blogspot.com
l:/bin/bash
fossy:x:1001:1001:FOSSology:/srv/fossology:/bin/bash (used to be /bin/false
but I changed it to /bin/bash in the hopes that it would work) <= password
is fossy
Thanks in advance for your help. Detailed config info can be provided to
anyone wishing to help me. Thank you!
--
Kurt Schroeder
[EMAIL PROTECTED]
http://kurtandsandy.blogspot.com
I am having a problem with Sun Java Studio Creator because the latest
version of the JDBC driver returns a field length of -1 for text fields.
My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I want
to use the data binding part of the SJSC tool I will need to convert my text
Newbie - please help me choose a direction.
I want to know what would be the best front-end app/language to use for
postgresql for exact form replication and ease of use. PHP, Python,
Java, Rekall (the Kompany), other? All suggestions welcome and appreciated.
Background---
I
--enable-recode code has been broken by the recent
> IPv6 code changes.
>
> If someone who uses it wants to fix it, step right up. If there are
> no volunteers, I will execute this TODO item:
> * Remove Cyrillic recode support
I was looking at it, shouldn't be too hard
On Wed, Jul 02, 2003 at 01:52:46PM -0400, Tom Lane wrote:
> Kurt Roeckx <[EMAIL PROTECTED]> writes:
> > I'll probably rewrite that code to use rangeSockAddr /
> > SockAddr_cidr_mask instead of having it's own cidr code.
>
> Given that it's been under de
When I try to start the backend it fails. Here is the server log entry:
postmaster successfully started
/usr/bin/postmaster: invalid argument -- output-meta
Try '/usr/bin/postmaster --help' for more information.
Please help!
-km
---(end of broadcast)-
I am having a problem with the zillions of:
pq_flush: send() failed: Broken pipe
FATAL: pq_endmessage failed: errno=32
messages being generated.
What causes this?
How can it be prevented?
-km
---(end of broadcast)---
TIP 1: subscribe and unsu
I'm getting these log entries:
ExecRestrPos: node type 18 not supported
ExecMarkPos: node type 18 not supported
Any idea what they mean?
TIA,
-km
_
Get more from the Web. FREE MSN Explorer download : http://exp
Query problems.
Updating table A(fqhcdata) based on values in table B(chn_jmembrm0).
Keys:
Table A: sbrno - char(15)
Table B: subscriber_number - varchar
*both fields have indexes
==
Query 1: (the most obvious solution)
This simple test function fails.
--
drop function testit(text);
create function testit(text) returns text as '
DECLARE
myval text;
BEGIN
myval:= $1;
return myval;
END;
' language 'plpgsql';
select testit('testing');
select testit(''testing'
Found these messages in the log this morning.
Can anyone explain why?
dropping tables for ucs...
NOTICE: RegisterSharedInvalid: SI buffer overflow
NOTICE: InvalidateSharedInvalid: cache state reset
TIA,
-km
Get Your Priv
How would I connect a Unix client (perl,psql,etc.) on one machine to a Unix
postgres backend on another machine?
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Hi,
Please add to the COPY command the option FIXED_WIDTH for the purpose of
exporting fixed width files.
TIA,
Kurt Miller
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
to do X
3 conscious competence
I do know how to X, but I have to think about it
4 unconscious competence
I know how to X and I do it without thinking about it
(Think of e.g. driving a car)
Kurt Seel, Systems Engineer
Unified Technologies Corp.
Phone : 610 964 8200
Email : kseel@ut{anti-spam]corp.com
To send me email, remove the {anti-spam] from the above address.
33 matches
Mail list logo
