I'm using compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm on CentOS 5 in
64bit mode.
The package did not create a libpq.so.4 link in /usr/lib64/, which
caused Apache to fail.
Regards,
Kevin Murphy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Devrim GÜNDÜZ wrote:
Hi,
On Wed, 2008-08-06 at 11:19 -0400, Kevin Murphy wrote:
I'm using compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm on CentOS 5
in 64bit mode.
The package did not create a libpq.so.4 link in /usr/lib64/, which
caused Apache to fail.
http://yum.pgsqlrpm
qlrpms.org) with yum.
When yum installs the PGDG postgresql-jdbc-8.3.3 RPM on CentOS 5, it
appears to want to drag in GCJ dependencies, but I want to use a Sun
JDK. The JDK is pre-installed by the Rocks V cluster distribution,
which is based on CentOS 5.
Thanks,
Kevin Murphy
--
Sent via pgsql-
Devrim GÜNDÜZ wrote:
On Thu, 2008-08-07 at 09:57 -0400, Kevin Murphy wrote:
When yum installs the PGDG postgresql-jdbc-8.3.3 RPM on CentOS 5, it
appears to want to drag in GCJ dependencies, but I want to use a Sun
JDK. The JDK is pre-installed by the Rocks V cluster distribution,
which is
Tom Lane wrote:
Kevin Murphy <[EMAIL PROTECTED]> writes:
Speaking as a near-ignoramus, would a simple RPM that wraps the binary
jar file make sense?
Sure, if you want to do it that way. We did in fact do it that way up
till about 8.0. We (or at least I) moved away from it beca
multiple memory models?
-Kevin Murphy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Devrim,
Thanks for the awesome resource of yumpgsqlrpms.org.
My life would be complete if it offered perl-DBD-Pg for CentOS 5!
I'll look around for a src rpm.
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
Joao Ferreira wrote:
Have you considered installing directlly from CPAN ?
# perl -MCPAN -e 'install DBD::Pg;'
On Fri, 2008-10-31 at 09:20 -0400, Kevin Murphy wrote:
My life would be complete if it offered perl-DBD-Pg for CentOS 5!
Yes, but I prefer a package in this
ith time zone' modifier in the
first example.
Thanks,
Kevin Murphy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Gregory Stark wrote:
Mohamed writes:
I want to match against a boolean field, that is, only true or false is
possible. I am thinking Btree but not sure.. correct?
No index is going to be particularly effective for boolean columns unless
they're very heavily skewed. You might find it
I've noticed that the argument to the \c (connect) meta-command is
case-sensitive. This doesn't seem to be consistent with other
meta-commands or the SQL standard of case-insensitive identifiers.
Would it hurt to change the behavior?
Regards,
Kevin Murphy
--
Sent via pgsql-gener
function unnest(anyarray)
returns setof anyelement as $$
select $1[X] from generate_series(array_lower($1,1),array_upper($1,1)) Y;
$$ language sql;
Please enlighten the unworthy!
Thanks,
Kevin Murphy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
/etc/sysctl.conf. I can have a cron job remove the shared memory
sysctls in /etc/rc if they reappear, but that would be a decidedly
imperfect kludge.
Kevin Murphy
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi all,
My searches at:
http://archives.postgresql.org/pgsql-general/
haven't been working for the last couple hours; the query times out.
Is this my problem or a real one?
-Kevin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
On Mar 28, 2005, at 1:40 PM, Joshua D. Drake wrote:
I don't see PostgreSQL either. That seems very odd as we are the second
widest used OSS database on Linux.
Yeah, they might as well just put up a graph of advertising dollars by
database instead of these poll results ;-)
Kevin M
On Apr 20, 2005, at 1:24 PM, Aaron Bingham wrote:
create table a (foo varchar);
insert into a (foo) values ('baz');
create table b (foo varchar);
insert into b (foo) values ('woof');
select '"' || foo || '"' as foo
from (select foo from a) as bar
union select foo from b;
No, it's doing
and genetic.chromosome = genetic.chromosome
and genetic.gl_left = framework.rank)
from framework
where name = 'D3S3610'
and layer = 'GL';
---
Is that the appropriate SQL behavior? Personally I don't care; I'm
just curious.
Thanks,
Kevin
e standard ./configure && make && sudo
make install :
ftp://ftp.gnu.org/gnu/readline/readline-5.0.tar.gz
then your postgresql compile should work fine.
-Kevin murphy
---(end of broadcast)---
TIP 2: you can get off all lists a
s_id | 2200 | 12237018 | 100 | 0 |
12237017 | 0 |1 | 1 | 0
| 0 | f | f | S |9
| 0 | 0 |0 |0 | 0 | f |
f | f
d against postgresql, but they don't. If there were a pool of
drupal/postgresql users willing to be testers, and module authors were
aware of this, that would help also. I've been too busy to dive in and
suggest/coordinate this, though.
-Kevin Murphy
--
nt thread about ram disks, but maybe this is a
situation that
might call for one?
The rest of this message contains details about the situation.
Thanks for the advice, as usual!
-Kevin Murphy
Sample query:
explain analyze select * from tagg
followed by CLUSTER):
CREATE TABLE table1 (cluster_col TEXT, col2 INTEGER);
CREATE INDEX idx1 ON table1(cluster_col);
INSERT INTO table1 (cluster_col, col2) SELECT cluster_col, col2 FROM table1;
CLUSTER idx1 ON table1;
Thanks,
Kevin Murphy
P.S. On another topic, did I gather correctly from a
command results in the error message: "set-valued function
called in context that cannot accept a set").
-Kevin Murphy
---(end of broadcast)---
TIP 6: explain analyze is your friend
Martijn van Oosterhout wrote:
On Wed, Aug 03, 2005 at 09:40:26AM -0400, Kevin Murphy wrote:
You have to wrap a scalar subquery in its own parentheses even where you
might think it to be unnecessary, such as when the subquery is the sole
argument to a function.
It first guess I
Peter Fein wrote:
Kevin Murphy wrote:
As an example, I wrote a function to explode, or unpack, the elements of
an array onto separate rows (its return type is SETOF whatever), but it
took me a while to figure out how to use it effectively in queries.
Mind posting it? I know I'v
;set-valued function called in context that cannot accept a
set" error. I've seen this error in the list archives, but I'm not sure
how to translate the simple cases discussed into this situation. I'm
sure it's something simple, but it's been eluding me.
Thanks,
1
1024.09
1024.09
9.95
-Kevin Murphy
Greg Stark wrote:
All that said clustering is indeed often quite effective. Especially if it
makes an index scan efficient enough to win over sequential scans you can see
some huge effects. It's most useful for tables that aren't undergoing lots of
updates and don't need to be reclustered often.
Mike Rylander wrote:
On 8/17/05, Manfred Koizar <[EMAIL PROTECTED]> wrote:
On Mon, 25 Jul 2005 17:50:55 -0400, Kevin Murphy
<[EMAIL PROTECTED]> wrote:
and because the number of possible search terms is so large, it
would be nice if the entire index could somehow be pr
a new table as an ordered select on the loaded table)?
(Indexes would of course be applied after the data load.)
Thanks,
Kevin Murphy
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-n
Neil Conway wrote:
Kevin Murphy wrote:
I just wanted to confirm that the COPY command always stores data in
the table in the order in which it appears in the import file.
This is not the case -- depending on the content of the FSM, the newly
added rows might be distributed throughout the
. Unfortunately, in order to rank the
articles by relevance, it is further necessary to come up with a result
set containing one row for each qualifying gene mention in the set of
matching articles. There can be any number of search terms (up to some
limit), so the actual query has to be b
C++ shared library from PG, but I
don't know enough to understand what problems might be associated with
using more complicated C++ code.
It would be great if some C++/C guru could make a thorough analysis of
C++ integration issues.
Thanks,
Kevin Murphy
---(e
is an 8-CPU machine that recently became disused in our research
department and looks like a nice potential PG host.
Thanks,
Kevin Murphy
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
know about prepared statements or know something I don't.
Thanks,
Kevin Murphy
P.S. I don't use PHP, but google informs me that PHP definitely has
prepared statement options: PEAR::DB, PDO in 5.X+, etc.
---(end of broadcast)---
TIP 2:
h 8.0.
Thanks,
Kevin Murphy
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
I'm hoping to see the parameters of prepared statements in the
postgresql log when using a JDBC client against postgresql 8.1?
I saw a post about using the V2 protocol.
Is there any downside to this?
Thanks,
Kevin
P.S. Looking at the driver documentation, I see that I can append the
protoc
I'd like to have a function that acts as a row filter (that can
optionally expand each row into multiple rows), but I don't know how to
wangle this such that the output is not enclosed in parentheses, i.e.
what I'm getting now is a single column of a composite type instead of
multiple columns m
Merlin Moncure wrote:
On 12/13/06, Kevin Murphy <[EMAIL PROTECTED]> wrote:
I'd like to have a function that acts as a row filter (that can
optionally expand each row into multiple rows), but I don't know how to
wangle this such that the output is not enclosed in parenthese
duct ID, so the additional groupings
could theoretically be unnecessary, but this is not implemented yet."
-Kevin Murphy
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
latest selection at the
end
push(@lines,$_);
}
}
Would it be possible to implement this as a function in PG?
Aside: I'm fantasizing about a postgresql archive of user-submitted
functions. Is the pgfoundry the closest thing to this?
-Kevin Murphy
--
nt you are,
how creative you are, your tolerance for abstraction, the number and
quality of programmers you want to be able to potentially contribute to
or maintain your code, etc, etc.
It's a big barnyard, and it all stinks. So let's just roll around in
Seneca Cunningham wrote:
On Sun, Apr 15, 2007 at 06:18:18PM -0400, Kynn Jones wrote:
Still, it would be nice to have more up-to-date instructions on how to
install PostgreSQL on OS X. Any pointers would be much appreciated!
Try the main documentation
And just for the record, PostgreS
.sysv.shmseg=8
kern.sysv.shmall=65536
I just started a 32-bit instance of PostgreSQL with no problems on
this box, and it showed:
sudo ipcs -m -b
Shared Memory:
T ID KEYMODE OWNERGROUP SEGSZ
m 1310715432001 --rw--- postgres staff 126763008
Thanks,
Kevin
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's plenty
of SYSV memory avai
A.M. wrote:
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check' fails
because of failure to allocate shared memory. There's plenty of
SYSV mem
Tom Lane wrote:
Kevin Murphy <[EMAIL PROTECTED]> writes:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's?
creating template1 database in /usr/local/src/postgresql-8.2.3/src/
test/regress/./tmp_check/data/base/1 ... FATAL: \
could
On Apr 19, 2007, at 3:21 PM, Kevin Murphy wrote:
Has anybody tried making a 64-bit PostgreSQL on an Apple XServe w/
Intel Woodcrest CPU's? My compile works, but the 'make check'
fails because of failure to allocate shared memory. There's
plenty of SYSV memory avai
Tablespace |Description
---+--+--++---
...
template1 | postgres | UTF8 | pg_default | Default template database
For some reason, I haven't succeeded by reading the docs and googling.
Thanks for jarring my memory,
Kevin Murphy
PostgreSQL 8.2.4
Richard Huxton wrote:
Kevin Murphy wrote:
Sleep deprived and surely doing something stupid here; I can't seem
to confer the ability to create databases on a regular user.
As a superuser: ALTER USER joe CREATEDB
Thanks, Richard and others who replied. I don't have to deal with
p
anyone) ever compare performance of PostgreSQL under PPC
Linux running on the G4 or G5?
-Kevin Murphy
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
I'm certainly not an AIX expert, but I remember my 32-bit AIX programs
being limited to 256MB of heap by default. When I linked, I think I had
to ask for more maximum data page space using something like:
-bmaxdata:0x4000
(which asks for 1GB, I believe)
-Kevin M
A Windows PostgreSQL guru who cares (;-)) might help this guy with his
benchmark of mysql, firebird, sqlite, and postgresql:
http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
Obviously I don't care (and I don't use Windows).
-Kevin Murphy
---(end of
nted to clone template0, you would leave out the "encoding
= 'UNICODE'" clause.
Gurus, any corrections or safety advisories you care to make?
Kevin Murphy
---(end of broadcast)---
TIP 6: explain analyze is your friend
Index Scan
Backward approach?
Thanks,
Kevin Murphy
Limit (cost=104804.79..110320.84 rows=25 width=229) (actual
time=1653.686..10381.264 rows=25 loops=1)
-> Index Scan Backward using merged_weight_date_idx on merged
(cost=0.00..31295593.98 rows=141839 width=229) (actual
time=3.888..10380.
ions, the
index scan would take forever while the alternative would be fine.
My curiosity has sunk below my need to get real work done, so I don't
require any further response.
If anybody has too much time on his or her hands, you can read what I
wrote (below) before I decided it wasn'
erstate the space requirements by half a unit.
If you want to exclude the system tables from the total database size,
then instead of pg_database_size(), you could use:
select pg_size_pretty(cast (sum(pg_total_relation_size(tablename)) as
bigint)) as size
from pg_tables where schemanam
PG tsearch2 users,
I notice there is an 8.1 backport of tsearch2 for 8.2
(http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch2WhatsNew).
Has anybody used this?
What are the performance differences between the new GIN index and GIST?
Thanks,
Kevin Murphy
s: 5772123
Total size of tuples: 1846434636 bytes
Total size of leaf tuples: 1779845516 bytes
Total size of index: 2006065152 bytes
(1 row)
Time: 193023.012 ms
Thanks,
Kevin Murphy
---(end of broadcast)---
TIP 5: don't forget to
on numerous previous occasions. Is there
heavy-handed moderation or filtering going on here?
Thanks,
Kevin Murphy
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Tom Lane wrote:
Kevin Murphy <[EMAIL PROTECTED]> writes:
Yesterday I sent two messages to pgsql-general@postgresql.org, and
neither one posted, as far as I can tell.
Perhaps your own incoming spam filtering is dropping the messages?
Hmm, I checked the spam filter folder, to no
I'm trying to test the 8.1 backport of the 8.2 GIN index and tsearch2
functionality.
The patch is applied successfully (to 8.1.4, on OS X 10.4.7 w/ xcode
2.3), the build and install goes well, stop & start of postmaster is
done, but initializing tsearch2 fails:
psql -U postgres minitest <
/
; collation - but I'd occasionally like to ORDER BY columns containing real UTF-8 data.
Would the pg_strxfrm() function get used in a new operator class function?
I'll read up on operator classes in chapter 32.14 of the docs, but if someone
has a simp
Tom Lane wrote:
Kevin Murphy <[EMAIL PROTECTED]> writes:
What is the answer to Filip's question? I didn't see an answer in the list
archives. I've seen several copies of Joe Conway's pg_strxfrm.c code on the
web, and it always refers to the Warn_restart varia
now,
but I looked it up: for a single-row insert, it's the OID of the new row;
otherwise, it's 0. The 1672036, on the other hand, means that 1,672,036 rows
were inserted.
-Kevin Murphy
---(end of broadcast)---
TIP 5: Have yo
y test again. Still, it would seem remarkable if a memory
error could produce my initial results rather than a crash or hang. I am
also feeling like compiling PG again, since it was initially compiled with
that bad DIMM (but again, what would the odds be?)
Tom, as always, thanks fo
default ''::character varying
chr | character varying(2) | default ''::character varying
assay_size | integer | default 0
pop_size| integer | default 0
seq_pos | integer | default 0
transcribed | character varying(1) | defa
if that's what the base query returns, and 0
rows if the base query return a single row.
What's a good way to do this?
Thanks,
Kevin Murphy
---(end of broadcast)---
TIP 8: explain analyze is your friend
I am pretty sure the answer is no, but ... is there any way to get
'ilike' to use an index? It seems like something that a lot of people
would want to do. Otherwise, should I just create redundant
case-mapped columns and use 'like'?
Thanks,
Kevin Murphy
--
On Sep 21, 2004, at 4:52 PM, Thomas F.O'Connell wrote:
You can use an index on an expression like "lower( col ) LIKE ... " as
long as the LIKE expression is left-anchored. See
Yes, I know that already. I wasn't talking about LIKE; I was talking
about ILIKE. The data in the column is mixed-case.
I receive the error message "Try to compose a less restrictive search
query or check spelling" regardless of search term when attempting to
search the list "PgSQL - General" via the mailing list archive search
form at:
http://archives.postgresql.org/pgsql-general/
---(en
k:
\COPY temp_table FROM STDIN WITH NULL AS '';
-Kevin Murphy
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
72 matches
Mail list logo
