On Thu, Jun 9, 2011 at 5:46 AM, Craig Ringer
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
On Wed, Jun 8, 2011 at 11:43 AM, Radosław Smogura
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 will transfer
> over net
On Fri, Jul 31, 2009 at 2:47 PM, Thom Brown 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 useful inform
On Mon, Jun 1, 2009 at 8:20 PM, Douglas Alan 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 can
> tell me how to
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 y
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 resour
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 po
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 Martij
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
> alusd
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
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, b
credited. I work 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 wa
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 positi
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.co
far off, no.
Perhaps a suboptimal plan 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
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
> quer
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
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
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
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 (afai
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:
SE
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 n
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 th
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 thr
24 matches
Mail list logo
