Hi ,
On a Postgresql database i like to obtain (using
an sql statement) the list of all user defined
indexes and their details specially the column
order by sort order. e.g. ASC or DESC. Any help
would be much appreciated.
2014 16:23, FarjadFarid(ChkNet) farjad.fa...@checknetworks.com
wrote:
Hi ,
On a Postgresql database i like to obtain (using an sql statement) the list of
all user defined indexes and their details specially the column order by sort
order. e.g. ASC or DESC. Any help would be much
Thanks Melvin, That worked for me. Great.
From: Melvin Davidson
[mailto:melvin6...@yahoo.com]
Sent: 15 August 2014 15:46
To: farjad.fa...@checknetworks.com;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] list of index
On a Postgresql database i like to obtain (using
an
: [GENERAL] list of index
On Fri, Aug 15, 2014 at 11:53 PM,
FarjadFarid(ChkNet)
farjad.fa...@checknetworks.com wrote:
I have done that. The important point is
obtaining the sort order of
each column in the index. Specially multi column
index.
Are there no views?
FWIW, I always find good source
Hi,
Quotation marks should be around both the name of
each and every column and their values.
Also replace column comas as separation character
for sql insert statement.
What has happened here is that the values from CSV
are directly into sql.
Hope this helps.
Best Regards
Hi,
Quotation marks should be around both the name of
each and every column and their values.
As the columns names are all lower case. You may
wish to remove all quotation marks which is much
easier.
But character value needs quotation mark.
Also replace the semi-column as
Hi Eugenio,
How you got about resolving this depends on your
project, the size of data.
For a simple case, which this seems to be. Simply
don't insert the serial column. E.g. remove both
name of the column and its corresponding value in
the insert statement.
Postgresql will insert these
Is the list of shorthand casts documented somewhere?
If so can you please direct me to it. A working URL would be great.
Many thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G Johnston
Sent: 09 December 2014 20:23
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] List of shorthand casts
FarjadFarid(ChkNet) wrote
Is the list of shorthand casts documented somewhere?
If so can you please
Got it thanks.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: 09 December 2014 21:40
To: FarjadFarid(ChkNet)
Cc: 'David G Johnston'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] List
Thanks.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: 09 December 2014 21:46
To: FarjadFarid(ChkNet); 'David G Johnston'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] List of shorthand casts
On 12/09/2014 01:37 PM, FarjadFarid(ChkNet) wrote
Is the list of shorthand casts documented somewhere?
If so can you please direct me to it. A working URL would be great.
Thank you.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
It sounds like your system had crashed several times.
My suggestion would be first ensure that your tables and indexes are not
corrupted.
Second suggestion is to ensure your index is tightly represents the data you
are accessing. The tighter it is the faster the response time. The less
memory
, FarjadFarid(ChkNet) [via PostgreSQL] wrote:
It sounds like your system had crashed several times.
My suggestion would be first ensure that your tables and indexes are not
corrupted.
Second suggestion is to ensure your index is tightly represents the data
you are accessing
Hi,
My approach would be to improve the uniqueness of each record/row. Otherwise
you'll have to traverse the entire table for every query. At 100/200 queries
per second you are asking for trouble on several fronts. Including crashing
your hard disk faster than need be.
Hope this helps. Good
...@postgresql.org] On Behalf Of FarjadFarid(ChkNet)
Sent: 01 April 2015 17:14
To: 'TonyS'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Would like to know how analyze works technically
Because your system had crashed. I would check everything from bottom up.
The duration of operation
Hi all,
Can someone please direct me as how to detect columns (serial) with
autoincrement option ?
Many thanks.
Best Regards
Farjad Farid
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Many thanks.
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: 02 September 2015 00:20
To: Tom Lane
Cc: FarjadFarid(ChkNet); pgsql-general@postgresql.org
Subject: Re: [GENERAL] Detecting autoincrement columns
Try this:
SELECT *
FROM information_schema.columns
WHERE UPPER
Sorry folks,
I should have included this in my last question.
How can I obtain the initial and incremental value of a serial entity?
Many thanks
Best Regards
Farjad Farid
] On Behalf Of Raymond O'Donnell
Sent: 07 September 2015 08:45
To: FarjadFarid(ChkNet); 'pgsql-general'
Subject: Re: [GENERAL] table dependencies
On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:
> No worries.
>
> I found a way.
>
Would you share it, for the archives?
Ray.
--
Raymo
Hi,
For data insertion purposes I need to identify "the lowest ranking tables"
(e.g. with least dependencies) to fill and work my way up.
I have looked a number of blogs but unfortunately these didn't work.
Is there a function or view to report dependencies of tables ? I have
Postgresql
No worries.
I found a way.
Best Regards
Farjad
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks Melvin. Much appreciate it.
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: 07 September 2015 14:38
To: Gavin Flower
Cc: r...@iol.ie; FarjadFarid(ChkNet); pgsql-general
Subject: Re: [GENERAL] table dependencies
All,
fwiw, I once wrote a plpgsql function to assist
Hi,
I am getting errors trying to insert multiple records in single statement in
table like this
CREATE TABLE "Lookup"."CNEnum1"
(
"Id" integer NOT NULL,
"Description" character varying(50),
CONSTRAINT "PK_Lookup_CNEnum1 " PRIMARY KEY ("Id")
)
WITH (
OIDS=FALSE
);
Assuming you have at least 16GB of memory. These numbers on a good hardware
server is not a real problem. On a bad server motherboard. Might as well use a
standard PC. With 32GB I have tested 10 times more connections. Not to
postgresql.
I would investigate everything from bottom up.
Also
Hi All,
I just saw this thread.
I tend to agree with the general idea of having a code of conduct. If you are
on a long distance journey then it will help to have road signs every now and
then. Following your nose won't hurt but doesn't necessarily help either! LOL
More seriously, on the
have said all I wish to say.
Whatever is the decision of the team I will happily support them.
Good luck.
Farjad Farid
From: James Keener [mailto:j...@jimkeener.com]
Sent: 06 January 2016 14:29
To: FarjadFarid(ChkNet); 'Karsten Hilbert'; pgsql-general@postgresql.org
Subject
nal Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Karsten Hilbert
Sent: 06 January 2016 11:32
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Code of Conduct: Is it time?
On Wed, Jan 06, 2016 at 11:22:17AM -0000, FarjadFa
06 January 2016 11:32
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Code of Conduct: Is it time?
On Wed, Jan 06, 2016 at 11:22:17AM -0000, FarjadFarid(ChkNet) wrote:
> I am not in favour of massive price structures but that there should
> be $100-$200 costs for smallest versi
Of James Keener
Sent: 06 January 2016 15:04
To: FarjadFarid(ChkNet); 'Karsten Hilbert'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Code of Conduct: Is it time?
> My only aim is further progress of postgresql.
Charging for it would do exactly that. Most people would simply switch to My
Of James Keener
Sent: 06 January 2016 15:04
To: FarjadFarid(ChkNet); 'Karsten Hilbert'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Code of Conduct: Is it time?
> My only aim is further progress of postgresql.
Charging for it would do exactly that. Most people would simply switch to My
January 2016 17:01
To: Jim Nasby; Melvin Davidson; FarjadFarid(ChkNet)
Cc: James Keener; Karsten Hilbert; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Code of Conduct: Is it time?
On 01/06/2016 08:13 AM, Jim Nasby wrote:
> (BTW, if your concern on enforcement is about control, not only
this clarifies all the points.
-Original Message-
From: James Keener [mailto:j...@jimkeener.com]
Sent: 06 January 2016 15:54
To: FarjadFarid(ChkNet); 'Karsten Hilbert'; pgsql-general@postgresql.org
Subject: Charging for PostgreSQL
As Melvin mentioned, this belongs in a new thread
I am constantly using SSD both on my OS and database and have none of these
problems.
However I don’t use SSD for O/S’s virtual memory.
>From what I have read of this thread.
Potentially there could also be a situation that SSD is hitting its limit of
auto recovery and has been
This might interest some members.
It has been announced by Intel's latest Skylake CPU has serious bug which hangs
applications with complex threading which postgresql could *potentially* fall
into. I don't know if anyone has experienced this or not.
"Hello All,
Intel has identified an issue
Sent: 11 January 2016 22:00
To: FarjadFarid(ChkNet); 'Kevin Grittner'; 'Regina Obe'
Cc: 'Tom Lane'; 'Karsten Hilbert'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Code of Conduct: Is it time? (WIP CoC)
Hello,
Below please find a WIP CoC for the PostgreSQL.Org project:
PostgreSQL Global D
Dear all,
Please let's not be pedantic and expect absolute legalistic perfection in
the wordings that has been put forward.
No doubt we all understand the spirit and the purpose of the wording. Which
is when we are consulting in the community we
are not to here to discuss other people's
I don't know about others.
But this whole thread has completely gone off the original track. With so many
splinter topics. It has no hope of ever completing with any kind of resolution
satisfying even 10% of contributors.
Can be please stick to the core original topics? Whether we agree with
Joshua and all,
Because of the current political environment we live in, even though I am
neither a Muslim nor a Jew I am a Baha'i, I think we should not discuss
religion or politics on this forum. All such topics can be discussed privately.
Thanks for your efforts.
Best Regards
Farjad
Subject: Re: [GENERAL] Asp.net 5 and EF6
On 2/4/2016 9:52 AM, FarjadFarid(ChkNet) wrote:
> I am not using EF7. It is actually EF6 under full .net 5
then why is the error...
> NU1007 Dependency specified was EntityFramework7.Npgsql >=1.0.0 but
> ended with EntityFramework7.Npgsql 1.0.0
but expecting another.
At least this is one of the problems.
-Original Message-
From: Arjen Nienhuis [mailto:a.g.nienh...@gmail.com]
Sent: 06 February 2016 16:53
To: FarjadFarid(ChkNet)
Cc: pgsql-general
Subject: Re: [GENERAL] Asp.net 5 and EF6
On Thu, Feb 4, 2016 at 5:46 PM, FarjadFarid
Hi I am trying to use certain features of Asp.net 5 using postgresql using
EF6.
I have downloaded the latest unstable version of npgsql and tried to connect
to my db.
But no luck.
I have posted a request to stackoverflow.com but haven't had any response at
all.
It is easy to
Before transferring the data.
Compare the default settings and logging configuration.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: 12 February 2016 04:49
To: Seb
Cc: pgsql-general@postgresql.org
ent: 04 February 2016 17:00
To: FarjadFarid(ChkNet); pgsql-general@postgresql.org
Subject: Re: [GENERAL] Asp.net 5 and EF6
On 02/04/2016 08:46 AM, FarjadFarid(ChkNet) wrote:
> Hi I am trying to use certain features of Asp.net 5 using postgresql
> using EF6.
>
> I have downloaded the
I am not using EF7. It is actually EF6 under full .net 5
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: 04 February 2016 17:29
To: FarjadFarid(ChkNet); pgsql-general@postgresql.org
Subject: Re: [GENERAL] Asp.net 5 and EF6
On 02/04/2016 09:18 AM
Dear all,
May I humble request that only plain text attachments should be posted. This
safe guards everyone against
from accidental viruses been added to the email in transit.
Perhaps this should have been on the CoC for everyone’s safety.
Thank you.
Whilst the problem with the old filing system is correct. May be you want to
ring out the best out of your current set up.
There are a few things you can do to improve these performance figures.
1) Turn off logging during insert.
2) Ensure logging is performed on a different disk than where
Whilst the problem with the old filing system is correct. May be you want to
ring out the best out of your current set up.
There are a few things you can do to improve these performance figures.
1) Turn off logging during insert.
2) Ensure logging is performed on a different disk than where
Tom, thanks for your unbiased detailed response.
Interesting post.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: 22 February 2016 05:06
To: Andrew Smith
Cc: pgsql-general@postgresql.org
Subject: Re:
A number of contributors have asked why we should have Coc.
Whilst we have been lucky so far. Unfortunately people behave differently when
writing emails. This is because over 50% of our interactions are through body
language and we don't see each other face to face. We don't really know each
ew?
-Original Message-
From: gwinkl...@gmail.com [mailto:gwinkl...@gmail.com] On Behalf Of Geoff
Winkless
Sent: 22 January 2016 11:21
To: FarjadFarid(ChkNet); Postgres General
Subject: Re: [GENERAL] Let's Do the CoC Right
On 22 January 2016 at 10:47, FarjadFarid(ChkNet)
<farjad.fa...@
gmail.com [mailto:gwinkl...@gmail.com] On Behalf Of Geoff
Winkless
Sent: 22 January 2016 12:48
To: FarjadFarid(ChkNet)
Cc: Geoff Winkless; Postgres General
Subject: Re: [GENERAL] Let's Do the CoC Right
On 22 January 2016 at 12:08, FarjadFarid(ChkNet)
<farjad.fa...@checknetworks.com> wrote:
>
&g
Sounds like a great feature.
How can it be tested?
I am particularly thinking of window servers and effect of this on a live
system and any performance issues.
It is an exciting feature. Thanks guys.
-Original Message-
From: pgsql-general-ow...@postgresql.org
Dear All,
There has been much development based on many good comments and broader
participation on this thread that I have seen in the past which no doubt is the
envy of many other companies and open source communities.
However we seem to have moved away from the core goal of this thread
I do agree with Dave on the points he has made.
Can we please add these so everyone is happy and finalise the CoC?
Thank you.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David E. Wheeler
Sent: 24 January 2016
Well done Joshua D. Drake and thank you for the hard work putting up with so
many comments.
Hope it is all worth it.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: 26 January 2016 19:01
To:
keep it that way.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Geoff Winkless
Sent: 22 January 2016 13:22
To: FarjadFarid(ChkNet)
Cc: Geoff Winkless; Postgres General
Subject: Re: [GENERAL] Let's Do the CoC Right
as a whole.
Hope this clarifies my position.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Geoff Winkless
Sent: 22 January 2016 13:22
To: FarjadFarid(ChkNet)
Cc: Geoff Winkless; Postgres General
Subject: Re: [GENERAL] Let's
000, FarjadFarid(ChkNet) wrote:
> The number of job losses around the world is huge. From mining to retail
or software industry.
> The writings is on the wall for large co-operates, especially where
software is concerned.
>
> All the predictions are pointing to greater success for smal
sing view!”).
If 50% disagree that this can happen then fine. I will go with the majority.
But let's finalise this thread and move on.
-Original Message-
From: gwinkl...@gmail.com [mailto:gwinkl...@gmail.com] On Behalf Of Geoff
Winkless
Sent: 24 January 2016 15:37
To: FarjadFar
...@commandprompt.com]
Sent: 24 January 2016 17:31
To: Geoff Winkless; FarjadFarid(ChkNet); Postgres General
Subject: Re: [GENERAL] CoC [Final v2]
On 01/24/2016 07:36 AM, Geoff Winkless wrote:
> We'll just need you and Dave to sign a legally binding contract that
> you will provide ind
LJK, Firstly thanks for bring this topic up. As many companies have to handle
attacks on their network.
Adrian thanks for the links specially the one covering connection pooling in
the first link. Answered by Pavel Stehule .
Definitely something to avoid.
I have done a fair bit of work on
Hi All,
I have managed to make npgsql with EF6 to work under asp.net5.
Let me if you needs the info as to how to set it up.
Best Regards
Farjad
Sorry, by the first solution I meant to separate the drive for your db files
from other tasks.
/
It sounds as if you have *one* server with 128GB of memory.
Therefore the probabilities are that you have too many tasks running at the
same time. Flushing the disk drives’
It sounds as if you have *one* server with 128GB of memory.
Therefore the probabilities are that you have too many task running at the same
time. Flushing the disk drives’ read/write cache.
Increasing the memory probably will not solve the problem. The most effective
solution would be
Another option which is growing in popularity is distributed in memory cache.
There are quite a few companies providing such technology.
Pricing can range from free to quite expensive.
One recommendation with these technologies is to test them under heavy load
conditions.
Good
The question to ask is what benefit would you gain by saving BLOB object on a
database than on say a flat file server or url on an ftp server? Specially
larger ones.
BLOB’s cause a lot problem for all DBs. Not unless the DB engine can understand
their structure and process them. It is
Sorry the URL should have been https://www.maytech.net/
Of course there are other companies in this space.
From: Moreno Andreo [mailto:moreno.and...@evolu-s.it]
Sent: 29 July 2016 12:08
To: FarjadFarid(ChkNet) <farjad.fa...@checknetworks.com>;
pgsql-general@postgresql.org
Subje
stomer. They also distributed servers around the
world.
Hope this helps.
From: Moreno Andreo [mailto:moreno.and...@evolu-s.it]
Sent: 29 July 2016 12:08
To: FarjadFarid(ChkNet) <farjad.fa...@checknetworks.com>;
pgsql-general@postgresql.org
Subject: Re: [SPAM] Re: [GENERAL] WAL di
Just came across this excellent research work done on memmove by T Herselman.
Bearing in mind memory is constantly moved in any database. This excellent set
of library would be very handy for those who work
at the deep end of postgresql.
In a nut shell, the library checks the
ra
Sent: 06 July 2016 22:15
To: FarjadFarid(ChkNet) <farjad.fa...@checknetworks.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Fastest memmove in C
FarjadFarid(ChkNet) wrote:
> Excellent research and could be well worth checking out. As it could
> improve the performance of
.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: 07 July 2016 18:02
To: Stephen Frost <sfr...@snowman.net>
Cc: Merlin Moncure <mmonc...@gmail.com>; FarjadFarid(ChkNet)
<farjad.fa...@checknetworks.com&g
Well done. This is a much needed conversion. As Peter’s article says, it does
open up more opportunities.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joy Arulraj
Sent: 14 August 2016 22:06
To: pgsql-general@postgresql.org
Subject:
This is probably the start of your quest into this project. No doubt you’ll
need to handle other queries.
So my suggestion is first to rationalise the data storage before digging any
deeper.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org]
Hi,
Personally where possible I would always internal features of any DB engine.
These are pre-compiled, tested for performance and are ingrained into the
system. So they can naturally be expected to be slightly faster than even
triggers. In the case of your question, why not use serial
Is there a package/library, for postgresql server, covering financial formula
equivalent to excel financial formulae?
Especially considering the quality and precision.
Many thanks.
Is there a package/library, for postgresql server, covering financial
formula similar to exc el financial formulae?
Especially considering the quality and precision.
Many thanks.
77 matches
Mail list logo
