Hi,
I am trying to do a custom build (and generate binary and source RPM)
package for PostgreSQL.
I know community already has a RPM package, but I am trying to do a custom
build.
I am using attached SPEC file. But I am not able to get binary rpm.
rpmbuild always gives me source rpm only. Is
Sameer Kumar wrote:
I am trying to do a custom build (and generate binary and source RPM) package
for PostgreSQL.
I know community already has a RPM package, but I am trying to do a custom
build.
I am using attached SPEC file. But I am not able to get binary rpm. rpmbuild
always gives
Hi,
On Fri, 2013-12-06 at 10:30 +, Albe Laurenz wrote:
Start looking here:
http://yum.postgresql.org/srpms/9.3/redhat/rhel-6-x86_64/repoview/postgresql93.html
The source RPMs contain the spec file.
Also, http://svn.pgrpms.org/browser/rpm/redhat/9.3/postgresql/ is the
SVN repo for 9.3
That
On Fri, Dec 6, 2013 at 7:08 PM, Sameer Kumar sameer.ku...@ashnik.comwrote:
Hi,
I am trying to do a custom build (and generate binary and source RPM)
package for PostgreSQL.
I know community already has a RPM package, but I am trying to do a custom
build.
I am using attached SPEC
On Fri, Dec 6, 2013 at 6:30 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Sameer Kumar wrote:
I am trying to do a custom build (and generate binary and source RPM)
package for PostgreSQL.
I know community already has a RPM package, but I am trying to do a
custom build.
I am using
Thanks everyone for helping.
If I were you, I'd simply take the community spec and modify it for my
needs, it is already really complete and contains automatic management of
for example translation files, smth that is always a pain to maintain
manually.
I agree and that is why I asked for it
When you click on a table in the Object browser you'll see in the SQL
pane the sql that is needed to create that table.
Which function can I call to get that SQL?
Best,
Peter
There is no ready available function to generate the reverse engineered
query.
pgAdmin III generates it from the metadata (table information) available.
On Fri, Dec 6, 2013 at 4:17 PM, Peter Kroon plakr...@gmail.com wrote:
When you click on a table in the Object browser you'll see in the SQL
Readers,
Admittedly, a biased place to ask (!), but for a new database project,
how best to evaluate whether postgresql or xquery should be used.
As a novice of postgresql and xml, am not sure what is most
appropriate for a new database that will be tested initially on a
local computer, then
use pg_dump -s can get the DDL SQL.
jov
在 2013-12-6 下午6:50，Peter Kroon plakr...@gmail.com写道：
When you click on a table in the Object browser you'll see in the SQL
pane the sql that is needed to create that table.
Which function can I call to get that SQL?
Best,
Peter
2013/12/6 Peter Kroon plakr...@gmail.com:
When you click on a table in the Object browser you'll see in the SQL
pane the sql that is needed to create that table.
Which function can I call to get that SQL?
You can use the pg_dump command line function for this:
pg_dump -s -t name_of_table
On 06-12-13 11:54, e-letter wrote:
Readers,
Admittedly, a biased place to ask (!), but for a new database project,
how best to evaluate whether postgresql or xquery should be used.
As a novice of postgresql and xml, am not sure what is most
appropriate for a new database that will be tested
Thanks, but i need a non command line option.
2013/12/6 Ian Lawrence Barwick barw...@gmail.com
2013/12/6 Peter Kroon plakr...@gmail.com:
When you click on a table in the Object browser you'll see in the SQL
pane the sql that is needed to create that table.
Which function can I call to
Hi,
thanks for your Answers.
@Rémi Cura
You suggest a kind of Full Text Search. I already had a try with the tsearch2
extension.
The issue is to realize the similarity search. I have to use many OR statements
with a low set of arguments.
That significantly slows the FTS down.
@Kevin
Is it possible to test an C extension module (.so file) without
installing a SHAREDIR/extension/extension_name.control file?
My test suite already runs initdb and the database as a non-postgres
user, but I don't see a way to override the extension control file location.
--
Florian Weimer /
Janek Sendrowski jane...@web.de wrote:
I didn't know that the pg_trgm Module provides KNN search
It does, although my own experience shows that it tends to be more
appropriate for name searches or similar smaller columns than for
big text columns. Using the war_and_peace table from another
Florian Weimer fwei...@redhat.com writes:
Is it possible to test an C extension module (.so file) without
installing a SHAREDIR/extension/extension_name.control file?
Well, you could just ignore the extension mechanism: do some
manual CREATE FUNCTION commands and test the functionality
through
Sorry, I used AND-statements instead of OR-statement in the example.
I notices that gin is much faster than gist, but I don't know why.
The query gets slow, because there are many non-stop words which appear very
often in my sentences, like in 3% of all the sentences.
Do you think it could be
there are several reason drive us to build ourselves rpm, the most important is
we want to install it in a directory self definition
and another reason is setting CFLAGS(add -mavx for example, high light at
previous ).
because, without this compile parameter, response time is suffering on dell
On 12/6/2013 11:04 AM, 吕晓旭 wrote:
I find something with top : CPU usage of each postgres process is not
so high when low concurrency, the highest one is about 50%.
but when concurrency gradually increased, some postgres process cpu
usage reach 100%, and keep a moment. and at these high
20 matches
Mail list logo
