Hello again,
I have been digging a bit more into this and I have seen that the increase
of the table size is not caused by the index, but by the data storage to
disk implementation. As it is explained at the documentation of
pg_largeobject (
http://www.postgresql.org/docs/9.2/static/catalog-pg-lar
On Wed, Oct 2, 2013 at 11:08 AM, Víctor Cosqui wrote:
> Hi all
>
>
> I am developing an application which uses postgres 9.2 to store binaries as
> oid objects.
>
> CREATE TABLE content (contentname text, contentoid oid);
>
> I am making some tests to evaluate how much HD space I will need to alloc
> Dear all,
>
> 2 days ago, I need to backup 2 databases in my Database server because I need
> to format the system and reinstalls again with the back up databases.
>
> After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary and I
> think giving the previous data directory /hd
On Sunday, March 20, 2011 11:13:57 pm Adarsh Sharma wrote:
> Dear all,
>
> 2 days ago, I need to backup 2 databases in my Database server because I
> need to format the system and reinstalls again with the back up databases.
>
> After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 bin
On Mar 21, 2011, at 11:43 AM, Adarsh Sharma wrote:
>
> But what I have noticed that there is 6 databases in my Postgres database and
> one database pdc_uima doesn't have any entry in \l command.
>
> However I restore it from my previous backup.
That should not happen. If the Binaries version
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Mar 21, 2011 at 11:43:57AM +0530, Adarsh Sharma wrote:
> Dear all,
>
> 2 days ago, I need to backup 2 databases in my Database server because I
> need to format the system and reinstalls again with the back up databases.
>
> After a fresh inst
Thanks a lot! It works as good as I wish
Best regards.
Michael Nolan wrote:
>
> On Tue, Apr 21, 2009 at 12:04 PM, jc_mich wrote:
>
>>
>> The problem is not the formula, the problem is the join. I've summarized
>> it
>> because is a large formula and I've got right results
>>
>>
> You're quit
On Tue, Apr 21, 2009 at 12:04 PM, jc_mich wrote:
>
> The problem is not the formula, the problem is the join. I've summarized it
> because is a large formula and I've got right results
>
>
You're quite correct that the problem is the join, because neither of the
examples you gave have any code to
The problem is not the formula, the problem is the join. I've summarized it
because is a large formula and I've got right results
Here is the complete code code, stores and clients have a longitude and
latitude, and ponderator is a demand variable:
SELECT distances.client_id, min(distances.dist)
2009/4/20 jc_mich
>
> Hello
>
> I have a table with clients and other with stores, I want to calculate
> minimum distances between stores and clients, the client name and its
> closer
> store.
>
> At this moment I can only get clients ids and minimum distances grouping by
> client id, but when I
On Mon, Apr 20, 2009 at 08:02:49PM -0400, David Wilson wrote:
> On Mon, Apr 20, 2009 at 7:39 PM, jc_mich wrote:
> > You've understood very well my problem, but also this query works as worse
> > than everything I did before, it throws as many rows as rows are contained
> > my tables clients and st
On Mon, Apr 20, 2009 at 7:39 PM, jc_mich wrote:
>
> You've understood very well my problem, but also this query works as worse
> than everything I did before, it throws as many rows as rows are contained
> my tables clients and stores. I only want to find for every client what
> store is closer to
You've understood very well my problem, but also this query works as worse
than everything I did before, it throws as many rows as rows are contained
my tables clients and stores. I only want to find for every client what
store is closer to him, I expect one client to one store and their distance
In response to jc_mich :
>
> Hello
>
> I have a table with clients and other with stores, I want to calculate
> minimum distances between stores and clients, the client name and its closer
> store.
>
> At this moment I can only get clients ids and minimum distances grouping by
> client id, but w
SydMosh wrote:
Hi, i'm kinda new on postgresql, so i have a doubt, i'm trying to make a
query look like this:
http://img90.imageshack.us/img90/9440/consultaen.jpg
I feel like it is something so simple, show the "SUM(price_serv) AS total"
on a new line, but i just can't find the way. I've read th
On Sep 25, 2008, at 4:59 PM, x asasaxax wrote:
Hi everyone,
I have this table:
create table cat(
cod integer,
cod_super integer,
constraint cod_super_fk Foreign Key(cod_super) references cat(cod),
constraint cod_pk Primary Key(cod)
);
insert into cat values(0, 1);
insert into cat val
* Narasimha Rao P.A ([EMAIL PROTECTED]) wrote:
> Does postgreSQL support distributive query processing?
PostgreSQL does not directly support splitting one query across multiple
nodes (cpus, machines, whatever). It's certainly possible to set up
distributed load balancing over some set of PostgreS
On Sun, 2004-09-26 at 01:49, maridu h.s.n.v.prasad wrote:
> subscribe
> end
>
> hai sir
> i am using the postgresql 7.2 my doubt is
> what is the command of to see the list of databases
> i create a database named "jntuoes"
> database created it's displayed
> but i want to know the command
>
Richard Huxton wrote:
sathish wrote:
dear groups,
i have a doubt in sql,
i have a table staff_skills in which i have set a table level
constraint to create a primary key of two fields .
so 'name' and 'skill' combinedly forms a primary key.
now the issue is in another table i have only
sathish wrote:
dear groups,
i have a doubt in sql,
i have a table staff_skills in which i have set a table level
constraint to create a primary key of two fields .
so 'name' and 'skill' combinedly forms a primary key.
now the issue is in another table i have only 'name' field and i wan
On Fri, Jun 11, 2004 at 15:12:36 +0530,
sathish <[EMAIL PROTECTED]> wrote:
> dear groups,
>i have a doubt in sql,
>i have a table staff_skills in which i have set a table level
> constraint to create a primary key of two fields .
>so 'name' and 'skill' combinedly forms a primary key.
21 matches
Mail list logo
