Thomas Kellerer wrote on 17.07.2010 18:29:
Want to do some experiments?
Apparently there *is* a substiantial overhead, but I suspected the
sending of the raw SQL literal to be a major factor here.
(Server and JDBC program were running on the same machine)
In case any one is interested.
Out
Tom Lane wrote on 17.07.2010 19:35:
Thomas Kellererspam_ea...@gmx.net writes:
Tom Lane wrote on 17.07.2010 16:36:
Well, nobody's offered any actual *numbers* here.
I measured the runtime as seen from the JDBC client and as reported by explain analyze
(the last line reading Total runtime
true?
Why would explicitely stating the columns be slower than relying on implicit
column ordering?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tom Lane wrote on 16.07.2010 18:40:
Thomas Kellererspam_ea...@gmx.net writes:
the explanation of the --inserts option of pg_dumps states that
The --column-inserts option is safe against column order changes, though even
slower.
The way I read this is, that
INSERT INTO table (column
Craig Ringer, 13.07.2010 05:11:
On 13/07/10 05:29, Thomas Kellerer wrote:
I would suggest to either manually change the autocommit mode from
within pg_upgrade or to add a note in the manual to disable/remove this
setting from psqlrc.conf before running pg_upgrade. Personally I think
the first
Thomas Kellerer, 12.07.2010 23:29:
Hi,
I'm trying pg_upgrade on my Windows installation and I have two
suggestions for the manual regarding pg_upgrade:
When specifying directories, pg_upgrade *requires* a forward slash as
the path separator. This is (still) uncommon in the Windows world
Thomas Kellerer, 12.07.2010 23:29:
Hi,
I'm trying pg_upgrade on my Windows installation and I have two
suggestions for the manual regarding pg_upgrade:
I found another problem and I'm not sure if this is a bug or a user error :)
My batch file to start pg_upgrade looks like
?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
before running pg_upgrade. Personally I think the first option
would be the better one.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
register page.
When I follow the download link from http://www.postgresql.org/download/ I wind
up at http://www.enterprisedb.com/products/pgbindownload.do but there is no
link to version 8.3
So how do I download the binaries only (no installer) bundle of Postgres 8.3
for windows?
Regards
Thomas
with the one-click installers
(different integer-datetime settings).
Ah, right I forgot that 8.3 was bundled differently ;)
Thanks for the quick response!
Cheers
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
convenience attributes of the google groups email system.
I read it through the gmane newsreader, so I get threaded display and can easily
scan the subjects.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
GrGsM, 06.07.2010 09:06:
Now i need a column in the same result of the query which shows the
difference between the two columns .
For Example :
the result shoud be
Closedate , status , NT028, NT031, NT050,NT062 , NT028-NT031
Please note the last column in bold, i need the difference .
regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
it happens fi at transaction timeout or you executed a broken/failed
statement und catched the exception
try { call invalid sql } catch (Exception e) {}
connection.commit() - exception throws here, happens automatically
inside your appserver
regards
Thomas
Am 01.07.2010 20:06, schrieb
=
(As you can see, I'm using Postgres 8.4.3 on Windows)
I understand that I could grant the necessary privileges to the role after
creating the database.
I'm just curious why the databse owner is not the owner of the public schema.
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql
MerCed, PoRsch, ToYot, MicroSof, OrAcl or
BangAlor
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
http://marksverbiage.blogspot.com/2010/05/mysql-what-are-you-smoking.html
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
John Gage, 25.06.2010 11:50:
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please disabuse
me of this idea if I am mistaken.
Getting really off-topic
constraints
- windowing functions
- recursive common table expressions
- the absence of a program to check the consistency of the data
- the ability to use a subselect in a DML statement that references the table
to be updated
- generate_series()
- array handling
Thomas
--
Sent via pgsql-general mailing
Thomas Kellerer, 25.06.2010 14:32:
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki
mai fawzy, 22.06.2010 10:38:
I have a table that has the following fields:
IDMoney Date State
1 20 2010-01-01 done
2 10 2010-01-02done
I need to select the values from this table to join them 2 another
select statement but the
some are better with
several small queries. An index that might be used in one engine to speed up a
select might be totally ignored by another.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Magnus Hagander, 07.06.2010 16:15:
On Mon, Jun 7, 2010 at 15:58, Thomas Kellererspam_ea...@gmx.net wrote:
Magnus Hagander, 07.06.2010 15:52:
Some AV software probably behaves fine.
Probably.
In case anyone is interested:
I have two development computers that run Postgres on Windows XP
Dennis Gearon wrote on 18.05.2010 19:05:
select * from pg_class where relkind IN IN (‘r’, ‘v’, ‘S’);
^^ ^ ^
You repeated the keyword IN, and you are using the wrong quotes (unless this is a
copy paste problem of a broken email client)
select *
performance using a command that is
usually executed only once in the lifetime of a database?
It's like saying The car from manufacturer A is slower than the one from
manufacturer B, because it takes 1 second longer to start the engine...
Thomas
--
Sent via pgsql-general mailing list (pgsql-general
the Fiat group:
a Fiat 127 (similar to a Fiat 500 nowadays) against a Ferarri Testarossa.
The first test was to get 3 people from Munich to Augsburg (approx. 70km), the
Ferarri lost with about 30 minutes difference because it had to drive two times
;)
Regards
Thomas
--
Sent via pgsql-general
this?
SELECT *
FROM your_table t1
WHERE dbd = (SELECT min(dbd)
FROM your_table t2
WHERE t2.dep = t1.dep
AND t2.arr = t1.arr
AND t2.resnr = t1.resnr)
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
will need a reboot, and that means probably one
reboot every month.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, p.sort_key||array[c.id]
from threads c
join thread_display p on c.parent_id = p.id
)
select id, parent_id, matpath, created
from thread_display
order by sort_key;
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
/DbProjects/SkypePostgresqlWhitepaper
Thank you very much for those two links. Very interesting reading indeed.
And also thanks to all the other replies in this thread. You've all
given me something to think about.
:o)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
with 8.4
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
(at least this is true for 2005)
I don't know if this is for compatibility reason or because of the performance
penalty that comes with it
And DB2 9.7 introduced MVCC as part of their Oracle compatibility.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
guys are aware of some recent generic tests/comparisons
between the two systems?
Regards,
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Andy Colson wrote on 29.04.2010 23:51:
Here is my query, which works:
select organization,
state,
(select max(idate) from times where customers.custid=times.custid and
taskid = 27) as lastdate,
age( (select max(idate) from times where customers.custid=times.custid
and taskid = 27) )
from
/Community_Guide_to_PostgreSQL_GUI_Tools
Regards
Thomas
[1] http://www.hsqldb.org/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dipti shah, 23.04.2010 13:17:
Thanks but I don't have text type in my table.
sysdb=# \d changelogtest
techdb=# INSERT INTO changelogtest (id, txid, txtime) values (5, 123, 'now')
except select id, txid, txtime
from changelogtest
where id=5;
'now' *is* a text type value
Thomas
--
Sent via
Andy, 21.04.2010 01:44:
No I haven't. I'm using MySQL right now. But I want to learn more
about Postgresql's Hot Standby and see if it offers a better
replication solution.
Can anyone share their experience about Postgresql replication
performance impact? Thanks.
You might be interested in
Ognjen Blagojevic, 21.04.2010 17:08:
More precisely, to run it without using TCP/IP port
No
and without installing as a service?
Yes (simply run pg_ctl manually from the command line)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
the average of the sums using:
SELECT avg(the_sum)
FROM (
SELECT one_field, sum(other_field) as the_sum
FROM the_table
GROUP BY one_field
) t
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
-CHECKPOINTS
Although I have no idea about the impact regarding performance. But I guess if
you don't have too many writes it might actually be OK.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
switched to using the ZIP packages completely because it is so
much easer (unzip, initdb, pg_ctl -register, done)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
and Avira
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Magnus Hagander, 01.04.2010 11:50:
2010/4/1 Craig Ringercr...@postnewspapers.com.au:
instead of %ProgramFile%. I bet half of the problems would go away if
the installer refused to put the data directory into c:\Program Files.
Yep - it's not a clever place to put it.
IIRC, that was modeled
and what abourt that :
http://www.postgresql.org/docs/8.4/interactive/functions-string.html
Le lundi 29 mars 2010 à 14:44 +0600, AI Rumman a écrit :
I need a query to get the initial letter of the words:
Like:
Ispahani Public School IPS
Ahmed Iftekhar AI
Any help
between the two tables, something like:
select c.relname, a.attname, def.adsrc
from pg_attrdef def
join pg_class c on def.adrelid = c.oid
join pg_attribute a on a.attrelid = c.oid and a.attnum = def.adnum
where c.relname = 'the_table_name'
Thomas
--
Sent via pgsql-general mailing list (pgsql
to specify that my file has
a header line?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Tom Lane wrote on 09.03.2010 18:21:
Thomas Kellererspam_ea...@gmx.net writes:
\copy foo (foo, bar) from foobar.txt delimiter as '\t' csv header
So how can I specify a tab character if I also need to specify that my file has
a header line?
Type an actual tab.
Blush
That easy
of the description for the COPY command, does this maybe mean
it is only valid for COPY but not for \copy?
if that is the case, it should be documented somewhere).
Or is this related to the value of standard_conforming_strings?
Thomas
--
Sent via pgsql-general mailing list (pgsql-general
Tom Lane wrote on 07.03.2010 16:34:
We wouldn't even support it at all because it's so syntactically messy and
inextensible
I like it :)
It's the only cross-DBMS way to write down a date or timestamp literal.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
are documented here:
http://www.postgresql.org/docs/current/static/catalogs.html
Thomas
P.S.: it's either Postgres or PostgreSQL but never Postgre ;)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
venkatra...@tcs.com, 05.03.2010 13:04:
Thanks Thomas for your reply.
when i am trying -
select * from pg_catalog.pg_proc.prosrc
You have to use:
SELECT prosrc
FROM pg_catalog.pg_proc
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Good advice ,tks both of you .
For database books ,I found so many good books on Oracle,some on
mysql,but db2 and postgres, so few.
I have to read some books on Oracle for some advanced topics,although
oracle and postgres are different ,I also get some useful info from
it .
I hope postgres will
sigh,I didn't find a book with enough internal topics.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it again. But do we need to keep these
files or there is any process can we run to clean these. Can you please
help?
Regards
My understanding is that the FSM files are the Free Space Map files.
But you should never ever under no circumstance delete files manually from the
data directory!
Thomas
) which of those functions is public and which is not?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I found not only WAL writer process write data to WAL log files ,but
also write process which I thought only write dirty buffer to data
file .
Could some body tell me the reason?Tks a lot !!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
://suckit.blog.hu/2009/09/29/postgresql_history
It would be interesting to know why the max. performance in the r/w scenario
for 8.4.1 is lower compared to 8.3.7 (and if maybe 8.4.2 fixed this)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
in
the sort of situations people run into in production deployments. I
think it was the right trade-off to make.
Thanks for the detailed answer!
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
want to see this result on the screen at psql prompt. Since it may
return multiple rows, a cursor has to be employed here.
Hmm, I don't understand your question.
When you run the query, psql will display the result...
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
And what about that :
http://www.postgresql.org/docs/8.4/interactive/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET
Maybe my french english disallowed me to understand right the question,
but I think that this item could help in a way!
Le vendredi 19 février 2010 à 11:04 +0100, Pavel Stehule
and simply use the English version of all programs?
Regards,
set LC_MESSAGES=English
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Nils Gösche wrote on 20.02.2010 00:20:
set LC_MESSAGES=English
Yes, that works very well for psql, thanks! However, pgAdmin is still in
German. Any other trick?
File - Options - User Language - English
works for me
Thomas
--
Sent via pgsql-general mailing list (pgsql-general
in the release notes)
You can also try pg_migrator. It was introduced with 8.4 and will upgrade the data
in-place (i.e. without a dump and restore)
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
A. Kretschmer, 11.02.2010 09:42:
In response to Thomas Kellerer :
Marc Lustig, 08.02.2010 11:36:
Hi, can we safely put the data from /var/lib/postgresql/8.4/main/ of
server x to /var/lib/postgresql/8.3/main/ of server y, considering
that the new target machine is running 8.3 whereas the old
2010 à 10:05 +0100, Albe Laurenz a écrit :
Florent THOMAS wrote:
I'm currently running on pg8.4 and I have a trigger with a loop :
FOR ventilation_local IN (SELECT * FROM XXX) LOOP
IF (mytest) THEN
ventilation_local.myfield:=mynewvalue;
END IF;
END LOOP;
my
Le mercredi 03 février 2010 à 14:38 +0100, Florent THOMAS a écrit :
Thank you,
As I posted on a french list, whene I start to develop trigger bigger
than 10lines, I always come back on developper habits and forget
database aspects.
So I WILL PRINT IT ON MY WALL : With records everything
, Wappler, Robert a écrit :
On 2010-02-03, Florent THOMAS wrote:
Dear laurenz Albe,
Thank you for answering so fast. for me, the variable ventilation_local
is defined as a record type. So as I wrote on the other mail, I made
some additionnal test because the doc precise that the syntax
Hello,
I'm currently running on pg8.4 and I have a trigger with a loop :
FOR ventilation_local IN (SELECT * FROM XXX) LOOP
IF (mytest) THEN
ventilation_local.myfield:=mynewvalue;
END IF;
END LOOP;
my problem is that the record doen't accept the new value.
I've chek before the
;
the first notice and the second one are different.
Unfortunately, when I get out from the LOOP, the result doesn't seems to
be updated in the table
Best regards
Le mercredi 03 février 2010 à 00:28 +0100, Florent THOMAS a écrit :
Hello,
I'm currently running on pg8.4 and I have a trigger
Hi,
If I were you, I worked like this.
First make a union of those three query
Then make a crosstab :
http://www.postgresonline.com/journal/index.php?/archives/14-CrossTab-Queries-in-PostgreSQL-using-tablefunc-contrib.html
documented here :
right or is ther a way to let the query generate the columns and
there name without naming them?
Best regards
Florent THOMAS
Hy everybody,
I have a problem with 2 triggers.
I work on 3 tables :
table A == with one trigger after insert that insert values in table B
Table B == with one trigger after insert that insert values in table C
Table C
As I insert values on table A, I have a message that indicates the
EXECUTE
, 2010 at 4:53 PM, Florent THOMAS mailingl...@tdeo.fr wrote:
Hy everybody,
I have a problem with 2 triggers.
I work on 3 tables :
table A == with one trigger after insert that insert values in table B
Table B == with one trigger after insert that insert values in table C
Table C
As I
record by setting the parent_id to NULL.
In my experience creating a cycle in the tree creates a lot of trouble that is
hard to come by.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
/static/monitoring-stats.html#MONITORING-STATS-VIEWS
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Scott Frankel wrote on 21.01.2010 18:34:
Hi all,
Is there a query I can use to find the location of a db cluster?
SELECT name,
setting
FROM pg_settings
WHERE category = 'File Locations';
You need to be connected as the superuser (usually postgres)
--
Sent via pgsql-general mailing
solution to the problem.)
Don't know if this will work with 8.3:
select regexp_split_to_table(k, ' ')
from x;
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tmp, 20.01.2010 11:25:
http://www.postgresql.org/docs/8.4/static/storage-page-layout.html
I fail to find the size of the *row* header on that link.
All table rows are structured in the same way. There is a fixed-size header
(occupying 23 bytes on most machines), followed by an optional null
these in postgres?
bytea is the datatype you are looking for
http://www.postgresql.org/docs/current/static/datatype-binary.html
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
)
http://databene.org/databene-benerator
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with the following message
The requested URL /postgresql/postgresql-8.5alpha-windows-binaries.zip was not
found on this server.
When I manually change postgresql-8.5alpha-windows-binaries.zip to
postgresql-8.5alpha3-windows-binaries.zip in my browser URL, things are working.
Regards
Thomas
--
Sent via
akp geek wrote on 31.12.2009 21:45:
Hi All -
We have 2 databases test and prod. Now they are out of sync (
of course they will be to some extent ). But there are some functions in
some schemas. we have to sync from prod to test. What I wanted to ask,
is there any tool that you
/current/static/sql-createfunction.html
Check out the /ROWS result_rows/ part.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
= dsc.objsubid)
WHERE a.attnum 0
AND NOT a.attisdropped
and c.relname = 'account'
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Dec 23, 3:44 pm, r...@iol.ie (Raymond O'Donnell) wrote:
On 23/12/2009 02:56, Thomas wrote:
And could you give me some info about postgres internals? Such as
ebooks or online articles.
There's quite a bit in the manual:
http://www.postgresql.org/docs/8.4/interactive/internals.html
I guess PID 19045 write data to the log file first when I insert data
into table ,but why did writer process also access the log file ?
Could some guy tell me some details ?
FYI:
postgres: writer process's PID is 18848 .
postgres test [local] idle's PID is 19045 .
[r...@localhost tmp]# lsof
Does it write data to data files to make buffer clean?if it
does ,but I can not find open files from the result of lsof -p
PID.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 12月22日, 下午11时26分, gryz...@gmail.com (Grzegorz Jaśkiewicz) wrote:
On Tue, Dec 22, 2009 at 10:19 AM, Thomas freebsd...@gmail.com wrote:
Does it write data to data files to make buffer clean?if it
does ,but I can not find open files from the result of lsof -p
PID.
writer actually takes
like 7.3 would support
that.
It works for 8.4 and I believe this was working with 8.3 and 8.2 as well
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PostgreSQL behaves the same (syntactically), regardless on where or how it
was installed
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Greg Smith wrote on 16.12.2009 22:44:
You've probably already found
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007
which was my long treatment of this topic (and overdue for an update).
There is an update:
have not specified enough details, so
people can only guess what is going wrong (if at all)
My best guess is:
- you are simply not closing your connections when you are don
- you have configured a connection pool that creates a high number of initial
connections
Thomas
--
Sent via pgsql
in Squirrel.
But maybe that prompting for parameters can be turned off somewhere (I don't
use Squirrel, so I cannot tell)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
John R Pierce wrote on 06.12.2009 00:01:
I downloaded the portable version of Postegresql from
http://greg.webhop.net/postgresql_portable
It works but the problem is that to start the server you must load it
from the gui. Instead since I want to start the server from my app, I
need to
to zero. But does zero refer to a Monday or a Sunday?
Regards
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
#FUNCTIONS-DATETIME-EXTRACT
dow:
The day of the week (0 - 6; Sunday is 0)
regards
Thomas
Thomas Kellerer schrieb:
Hmm, I don't see that in there.
It just states that the field will be set to zero. But does zero
refer to a Monday or a Sunday?
Regards
Thomas
--
Sent via pgsql-general
Thomas Markus, 27.11.2009 09:41:
Hi,
not all to zero : that are less significant than the selected one set
to zero (or one, for day and month)
Sorry, I missed the or one part.
see
http://www.postgresql.org/docs/8.1/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
dow: The day
801 - 900 of 1844 matches
Mail list logo