On Thu, Jun 9, 2011 at 5:46 AM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 09/06/11 03:07, Isak Hansen wrote:
While MD5 is considered broken for certain applications, it's still
perfectly valid for auth purposes.
MD5 rainbow tables can be calculated quickly using services easily
On Wed, Jun 8, 2011 at 11:43 AM, Radosław Smogura
rsmog...@softperience.eu wrote:
You should actually only consider safty of storing of such passwords in
database. If with md5 the password isn't digested like in DIGEST HTTP auth,
and only md5 shortcut is transfferd it has no meaning if you
On Fri, Jul 31, 2009 at 2:47 PM, Thom Brownthombr...@gmail.com wrote:
Hi all,
We're migrating the contents of an old MSSQL server to PostgreSQL 8.3.7, so
a full conversion is required. Does anyone know of any guides which
highlight common gotchas and other userful information?
As for other
On Mon, Jun 1, 2009 at 8:20 PM, Douglas Alan darkwate...@gmail.com wrote:
I'd like to manually alter the statistics for a column, as for the column in
question the statistics are causing Postgres to do the wrong thing for my
purposes. (I.e., a Seq Scan, rather than an Index Scan.) If someone
On Mon, Nov 17, 2008 at 12:03 PM, Isak Hansen [EMAIL PROTECTED] wrote:
On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any pointers what settings I do need to make
On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any pointers what settings I do need to make,
please let me know.
Did you already try changing shmall as Martijn
On Mon, Nov 17, 2008 at 1:15 PM, Howard Cole [EMAIL PROTECTED] wrote:
Hi,
I am running multiple 8.2 databases on a not-so-powerful W2K3 server - and
it runs great - for the majority of time. However I have some monster
tsearch queries which take a lot of processing and hog system resources -
On Mon, Nov 17, 2008 at 12:11 PM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
Yes, I did ;)
Still the same error, i.e. unable to allocate shared memory? What does
sysctl -a | grep shm say?
Isak
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Mon, Nov 10, 2008 at 12:35 PM, Andrus [EMAIL PROTECTED] wrote:
explain analyze select count(*)::INTEGER as cnt
from dok
WHERE dokumnr IN
(869906,869907,869910,869911,869914,869915,869916,869917,869918,869921 )
and
dokumnr NOT IN (SELECT dokumnr FROM bilkaib WHERE
alusdok='LY')
On Wed, Oct 29, 2008 at 9:18 PM, Kevin Galligan [EMAIL PROTECTED] wrote:
I'm approaching the end of my rope here. I have a large database.
250 million rows (ish). Each row has potentially about 500 pieces of
data, although most of the columns are sparsely populated.
*snip*
So, went the
On Tue, Oct 28, 2008 at 11:41 PM, Tom Allison [EMAIL PROTECTED] wrote:
I was using macports but got into a cluster-F on versions and multiple
installs. After a spell I had all four versions 8.0 - 8.3 installed in
order to use postgres, ruby, perl, and rails together.
I use apple's ruby, but
On Mon, Oct 13, 2008 at 2:57 AM, justin [EMAIL PROTECTED] wrote:
[...] Also you want to split out the debit and credits instead of
using one column. Example one column accounting table to track values
entered how do you handle Crediting a Credit Account Type. is it a negative
or positive
with accountants all day, and this is what
they expect.
Of course either approach works, but I've come to prefer the single-column one.
Isak Hansen wrote:
On Mon, Oct 13, 2008 at 2:57 AM, justin [EMAIL PROTECTED] wrote:
[...] Also you want to split out the debit and credits instead of
using one
On 1/10/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I have not found anything about preparing unnamed statements. What
does it mean?
Unnamed statements are what the driver uses before it hits the
prepareThreshold limit. Once it has determined the statement will be
reused many
On 1/10/08, Sim Zacks [EMAIL PROTECTED] wrote:
I just upgraded my database server from 8.0.1 to 8.2.4
Most things went very well, but I have a couple of queries that really slowed
down with the new server.
On 8.0.1 the query took less then 3 seconds to complete. On 8.2.4 the same
query
(I
is picked due to configuration issues, e.g.
memory constraints? Could you post your postgresql.conf as well?
Kind regards,
Isak
Sim
Isak Hansen wrote:
On 1/10/08, Sim Zacks [EMAIL PROTECTED] wrote:
I just upgraded my database server from 8.0.1 to 8.2.4
Most things went very well, but I
On 1/10/08, Scott Marlowe [EMAIL PROTECTED] wrote:
On Jan 10, 2008 12:33 PM, Sim Zacks [EMAIL PROTECTED] wrote:
Perhaps a suboptimal plan is picked due to configuration issues, e.g.
memory constraints? Could you post your postgresql.conf as well?
Below is the postgresql.conf file for
On 12/12/07, Enrico Sirola [EMAIL PROTECTED] wrote:
Hello Isak,
Isak Hansen ha scritto:
Have a look at the cluster operation;
http://www.postgresql.org/docs/8.3/static/sql-cluster.html.
AFAIK it does lock duplicate the whole table during reordering,
which may or may not be an issue
Bah, evil google interface. My reply was ment for the list.
On 5/7/07, Isak Hansen [EMAIL PROTECTED] wrote:
On 5/7/07, Christopher S Martin [EMAIL PROTECTED] wrote:
sysctl -a reveals the following:
kern.sysv.shmmax: 12582912
Maximum size of shared memory segment (afaik bytes - needs
On 5/7/07, Andrew Kroeger [EMAIL PROTECTED] wrote:
Jonas Henriksen wrote:
explain analyze SELECT max(date_time) FROM data_values;
Goes fast and returns:
In prior postgres versions, the planner could not take advantage of
indexes with max() (nor min()) calculations. A workaround to this was
On 3/1/07, Shaun Johnston [EMAIL PROTECTED] wrote:
Hi
Apologies in advance for the verbosity of my explanation for this
problem, but I think it's all pertinent.
I have a fairly simple query which postgresql's query planner seems to
be interpreting / optimising in interesting ways:
Query:
We have a multi-tenant db with a lot of DDL along these lines:
journal_entry (
id serial,
tenant_id integer not null,
entry_date datetime not null,
description varchar(255),
primary key (id),
foreign key (tenant_id) references tenant (id)
);
tx (
id serial,
journal_entry_id integer not
On 11/30/06, John McCawley [EMAIL PROTECTED] wrote:
I am faced with a very new problem for me, which is that my app is going
to be used directly by several companies utilizing one server. (i.e.
these companies will be able to go under the hood quite a bit more
than we typically allow with this
I have the following two tables:
create table a (
id serial primary key,
);
create table b (
id serial primary key,
a_id int4 references a (id),
amount decimal(16, 2)
);
and would like a constraint to guarantee that sum(b.amount) = 0 group
by b.a_id.
From my testing so far, and this
24 matches
Mail list logo