will give you a measurement of your expected performance that
is much more meaningful then my ramble above. :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Bill Thoen wrote:
I
and then kill a specific bad query?
Maybe this is not missing functionality, it can do it and I just don't
know how. Anybody want to wisen me up? :)
Terry
Terry Fielder
te...@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Home
give you what you want
if you want to see all SQL statements.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Dave Potts wrote:
I am using a 3rd front end to generate postgres requests
Howard Cole wrote:
Hi Marijn, Andreas,
I think Andreas is right, note the ordering of characters in the above
example as [ ^] rather than [^ ].
So if the '^' is taken as literal '^', can I check for the beginning
of a string in the brackets,
Why do you need to? Check for the beginning o
Does the remote server have the relevant port opened up in its firewall?
Is postgres set to allow TCP/IP connections in the postgresql.conf?
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
the 8.2 "resolves index locking issues" was the concern for an 8.1 install.
Should I add a primary key column of serial? Will that help?
If anyone has any ideas it would be appreciated.
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great
Responses below.
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Terry Fielder <[EMAIL PROTECTED]> writes:
Under pg 7.x the system performed fine.
In 8.1.
aster
2577 root 10 -5 000 D1 0.0 22:59.43 kjournald
4949 root 15 0 12996 1336 792 S1 0.0 38:54.10 top
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416
My 2 cents:
I used to get a lot of these sharelock problems.
Users using different records, but same tables in different order.
(apparently 7.x was not as good as 8.x at row level locking)
I was advised to upgrade from 7.x to 8.x
I did, and all those sharelock problems went away.
Terry
Terry
You may encounter many things in life which you may regret having done.
Converting from M$ SQL to PostgreSQL is probably *not* one of them.
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Arnaud Lesauvage <[EMAIL PROTECTED]> writes:
When trying to import a 20M rows csv file into PostgreSQL, I
get :
ERROR: out of memory
État SQL :53200
Détail :Failed on request of size 1073741823.
Contexte : COPY tmp, line 1
Can you put together a self-containe
7.4.3
And the records are gone from pg_locks, how much time after the
deadlock do I have before they are purged?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Tom Lane wrote:
Terry
r
entities are behind the transaction number?
Thanks in advance
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
y, you can create a .pgpass file in the users home directory
(if ident not available, but you *need* to think about the permissions
of this file and ramifications)
Terry
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax:
Is there an chance the rows are being inserted in a transaction that
fails and rolls back? Maybe look at all the lines that were inserted
with that order, and try them manually in psql, character for character,
and see if an error pops up for any of the lines?
Terry Fielder
[EMAIL PROTECTED
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Matthew Hixson wrote:
http://www.enterprisedb.com/news_events/press_release
h was the goal you
requested)
3) In SQL there is almost always more then 1 way of doing something,
you have now seen 2. There may be more, possibly even better ways.
Experts care to comment? :)
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf
SELECT id, get_category_text_path(id)
FROM category
WHERE id IN (
SELECT c.id
FROM category AS c
ORDER BY c.rank
LIMIT 5
)
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Markus
I second Tom:
badblocks and memtest86 are what I use and works great on all kinds of
hardware. You don't even need a specific OS for memtest86 because you
can make a bootable floppy and test any old piece of hardware it recognizes.
Terry
--
Terry Fielder
[EMAIL PROTECTED]
Asso
)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
03:57:26 PM:
create table fooa (col1 varchar(30))
go
create table bara (col1 varchar(300))
go
insert into fooa values ('Danniel ')
go
insert into bara values ('Danniel ')
go
select * from fooa,bara where fooa.col1=bara.col1
go
Returns:
DannielDanniel
I think that the is
t=# SELECT 'a '::char = 'a '::char;
?column?
--
t
---(end of broadcast)-------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
alues ('Danniel ')
go
insert into bar values ('Danniel ')
go
select * from foo,bar where foo.col1=bar.col1
go
Result set:
Danniel Danniel
-Original Message-
From: Terry Fielder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 19, 2005 1:39 PM
T
the language, then they must
compare that way.
Perhaps there are some nuances that I am not aware of. But that is how
things ought to behave, if I were king of the forest.
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Terry Fielder
www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Terry Fielder
[EMAIL PROTECTED]
Associate Dir
dity to "dumb
it down" for the weak application developer, let's not do that.
Terry
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
--
Terry Fi
ecause a binary search is used (very fast).
mysql> SELECT INTERVAL(23, 1, 15, 17, 30, 44, 200);
-> 3
mysql> SELECT INTERVAL(10, 1, 10, 100, 1000);
-> 2
mysql> SELECT INTERVAL(22, 23, 30, 44, 200);
-> 0
--
Terry Fielder
[E
. Please let me
know
Note: i can able to connect with my local ip address. The issue which
i faced when i access through the public ip address.
--
Terry Fielder
[EMAIL PROTECTED]
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
You will need to rewrite or cast the expression
I have tried (bit) 0, bit(0), bit 0, etc but have not found a way to do
casting. Can anyone help me to set a default value for a bit datatype
field?
Thanks
Terry Fielder
[EMAIL PROTECTED]
---(end of broadcast)---
29 matches
Mail list logo
